JDBC Driver for SQL/MX Programmer's Reference

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 VARCHAR_WITH_LENGTH data types only when using the SQL/MX
supported character sets listed in the subsequent table.
The JDBC/MX driver encodes and decodes String data types as a function of the associated
character set name for the particular SQL database column independent of the default encoding.
The format of the Java file.encoding property is:
-Dfile.encoding=encoding
Note: SQL/MX supports a subset of encoding sets supported by NonStop Server for
Java 4.
Corresponding SQL/MX Character Sets and Java Encoding Sets
SQL/MX
Character
Set
Corresponding
Java Encoding
Set—Canonical
Name for
java.io API
Corresponding Java
Encoding
Set—Canonical Name
for java.io and
java.lang API
Description