JDBC Driver for SQL/MX Programmer's Reference

Do not share JDBC Java objects--such as Statement or ResultSet objects--across
threads for purposes other than canceling the SQL operation with the Cancel() method.
●
Be aware of the non-preemptive nature of the thread implementation in NonStop Server for
Java 4. A CPU-bound thread runs to its completion without providing an opportunity for the
thread scheduler to schedule a different thread.
●
Setting Batch Processing for Prepared
Statements
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
●