MX 2.x)

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

Java applications using the JDBC/MX driver can specify the Java file.encoding property to set the default encoding

to any character set supported by Java if no SQL literals exist in the program. If the program has SQL literals, the

program should use only the Java encoding sets that correspond to SQL/MX supported sets.

The JDBC/MX driver supports the reading and writing of SQL CHAR, VARCHAR, VARCHAR_LONG, and