JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

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” (page 45).
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.
Table 8 Corresponding SQL/MX Character Sets and Java Encoding Sets
Description
Corresponding Java Encoding
Set-Canonical Name for
java.io and java.lang API
Corresponding Java
Encoding Set-Canonical
Name for java.io API
SQL/MX
Character Set
Single-character, 8-bit, character set for
character-data type. It supports English
ISO8859_1ISO-8859-1ISO88591
and other Western European
languages.
Universal Character Set encoded in 2
bytes. Double-character Unicode
UnicodeBigUnmarkedUTF-16BEUCS2
character set in UTF16 big-endian
encoding.
NOTE: UCS2 is supported in SQL/MX
tables only.
42 Accessing SQL Databases with SQL/MX