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

–Djdbcmx.clobTableName=mycat.myschema.myLobTable
• By using the java.util.Properties parameter in the getConnection method of
DriverManager class. The properties passed through the Properties parameter have
precedence over the command line properties.
• By setting either of these properties in the DataSource. See “Connecting Using the DataSource
Interface” (page 23).
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 Oracle documentation. For more
information, see Supported Encodings.
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 HP NonStop SQL/MX Release 3.2.1 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 applications, because this pooling can dramatically help the performance of many
applications.
minPoolSize Property
Limits the number of physical connections that can be in the free connection pool. Specify the
minPoolSize property as:
int
JDBC/MX Properties 27