Stimmen - 0, Durchschnittliche Bewertung: 0
(
)
)
|
Dieses Gerät hat auch andere Anweisungen:
PC Desktops - HP Integrity NonStop H-Series (16.73 mb)
PC Desktops - HP Integrity NonStop H-Series (957.56 kb)
PC Desktops - HP Integrity NonStop H-Series (881.66 kb)
PC Desktops - HP Integrity NonStop H-Series (965.62 kb)
PC Desktops - HP Integrity NonStop H-Series (676.93 kb)
PC Desktops - HP Integrity NonStop H-Series (393.72 kb)
PC Desktops - HP Integrity NonStop H-Series (776.57 kb)
Anleitung Zusammenfassung
You can improve the performance of batch processing when using the PreparedStatement.executeBatch()
method by setting the batchBinding property. When the batchBinding property is set, the statements are
batched in the executeBatch() operation.
When a JDBC application sets the batchBinding property, the JDBC/MX driver allocates resources relative to
the specified binding size.
To set the batchBinding size, specify the batchBinding property in the command line. The syntax is:
-Djdbcmx.batchBinding=binding_size
where binding_size is a positive, signed, long integer that specifies the maximum number of
PreparedStatement.executeBatch() method statements that the JDBC/MX driver can bind
together for execution. The integer value can be in the range of 0 to 2 gigabytes.
Considerations
The values allowed for binding_size can result in your application running out of memory. Check that
you set the binding_size to a size appropriate for the memory limits.
If the number of statements is greater than the binding size, the JDBC/MX driver breaks the execution
of statements into blocks whose sizes are based on the binding size.
Even if the JDBC application does not call for batch execution, setting the jdbcmx.batchBinding
property causes the allocation of database resources relative to the specified binding size.
When the jdbcmx.batchBinding property is not set, the PreparedStatement.executeBatch() method
returns a row-count array that contains the number of rows affected by the corresponding statement
for each item in the array. By default, the JDBC/MX driver performs batch processing by returning a
row-count array.
When the jdbcmx.batchBinding property is set, the detailed information indicated in the preceding
bulleted item is no longer available. If the statement execution succeeds, the row-count item is set to
Statement.SUCCESS_NO_INFO in compliance with the JDBC 3.0 specification. The
PreparedStatement.getUpdateCount() method returns the total number of rows affected by all the
statements executed by the PreparedStatement.executeBatch() method.
Setting the reserveDataLocators Property
The reserveDataLocators property sets the number of data locators to be reserved for a process for storing
data in a LOB table. The default value for reserving data locators is 100. The property is of the form:
jdbcmx.reserveDataLocators=n
where n is an integer value of the number of data locators to be reserved. Do not set a value
much greater than the number of data locators actually needed. For more information about
data locator use, see Reserving Data Locators.
To change this value for a JDBC application, specify this property from the command line. For example, the
following command reserves 150 data locators for program myProgramClass.
java -Djbcmx.reserveDataLocators=150 myProgramClass
Supported Character Set Encodings
...Dieses Handbuch ist für folgende Modelle:
PC Desktops - HP Integrity NonStop J-Series (619.43 kb)