JDBC Driver for SQL/MX Programmer's Reference

ISO88591 Property
The ISO88591 character set mapping property corresponds to the SQL/MX ISO88591 character set,
which is a single-byte 8-bit character set for character data types. The ISO88591 character set
supports English and other Western European languages. Specify the ISO88591 property as
String
The default value is DEFAULT which uses the default Java encoding when accessing and writing to
ISO88591 columns. The value can be any valid Java Canonical Name as listed in the "Canonical
Name for java.io and java.lang API" column of the Sun documentation, Supported
Encodings (http://java.sun.com/j2se/1.4.2/docs/guide/intl/encoding.doc.html).
For example, if KANJI data has been stored in an ISO88591 column in an SQL/MP table (accessed
through SQL/MX) and has been read and written to the database using the column character set, you
can specify the following property to ensure the correct encoding:
-Djdbcmx.ISO88591=SJIS
mploc Property
The property mploc specifies the Guardian location in which SQL tables are created. The format
for mploc is:
[\node].$volume.subvolume
Java applications using the JDBC/MX driver can specify mploc by using the system property
mploc with the -D option in the command line.
-Djdbcmx.mploc=mploc
For example with the DriverManager object, in the OSS environment, specify the mploc
property in either of the following forms:
-Djdbcmx.mploc=[\\node.]\$volume.subvolume
or
-Djdbcmx.mploc='[\node.]$volume.subvolume'
For more information, see the SQL/MX Reference Manual.
maxStatements Property
Sets the total number of PreparedStatement objects that the connection pool should cache.
This total includes both free objects and objects in use. Specify the maxStatements property as:
int
The integer can be 0 through 2147483647. Any negative value is treated like 0. The default is 0,
which disables statement pooling. HP recommends that you enable statement pooling for your JDBC