JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

Client-Side Properties
Server-Side Properties
Type 4 driver properties that effect client-side operations and server-side are summarized in the following tables. For the detailed description,
click the link provided in the property name.
Note: Unless otherwise noted in the brief description, the particular property applies to the DataSource object, DriverManager
object, and ConnectionPoolDataSource object.
Client-Side Properties
Table 4.1. Connection Control Properties
Property
Name
Description Default Value
dataSourceName Specifies the registered DataSource or ConnectionPoolDataSource name. (Can be
set only on the DriverManager object.)
None
loginTimeout Sets the time limit that a connection can be attempted before the connection
disconnects.
60 (seconds)
networkTimeout Sets a time limit that the driver waits for a reply from the database server. 0 (No network timeout is
specified.)
Table 4.2. Pooling Management Properties
Property
Name
Description Default Value
initialPoolSize Sets the initial connection pool size when connection pooling is used with the Type 4
driver. (Ignored for connections made through the ConnectionPoolDataSource object.)
-1 (Do not create an
initial connection pool.)
maxIdleTime Set the number of seconds that a physical connection can remain unused in the pool
before the connection is closed.
0 (Specifies no limit.)
maxPoolSize Sets the maximum number of physical connections that the pool can contain. -1 (Disables
connection pooling.)
maxStatements Sets the total number of PreparedStatement objects that the connection pool should
cache.
0 (Disables statement
pooling.)
minPoolSize Limits the number of physical connections that can be in the free connection pool -1 (The minPoolSize
value is ignored.)
Table 4.3. Operations on CLOB and BLOB Data
Property Name Description Default
Value
blobTableName Specifies the LOB table for using BLOB columns. None
clobTableName Specifies the LOB table for using CLOB columns. None
reserveDataLocators Sets the number of data locators to be reserved for a process that stores data in a LOB
table.
100
Table 4.4. Internationalization Properties
Property Name Description Default Value
ISO88591 Sets character-set mapping that corresponds to the SQL/MX ISO88591
character set.
ISO88591_1
KANJI Sets character-set mapping that corresponds to the SQL/MX KANJI
character set.
SJIS (which is shift-JIS, Japanese)
KSC5601 Sets character-set mapping that corresponds to the SQL/MX KSC5601
character set.
ECU_KR (which is KS C 5601,
ECU encoding, Korean)
language Sets the language used for the error messages. None
translationVerification Defines the behavior of the driver if the driver cannot translate all or FALSE