JDBC Type 4 Driver 2.0 Programmer's Reference (SQL/MX 2.x)

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 part of an
SQL statement or SQL parameter.
FALSE
Table 4.5. Logging and Tracing Properties
Property Name Description Default Value
T4LogFile
Sets the name of the logging file for the
Type 4 driver.
The name is defined by the following pattern:
%h/t4sqlmx%u.log