JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

Table 4 Pooling Management Properties
Default ValueDescriptionProperty Name
-1 (Do not create an initial
connection pool.)
Sets the initial connection pool size when connection pooling
is used with the Type 4 driver . (Ignored for connections made
through the ConnectionPoolDataSource object.)
initialPoolSize
0 (Specifies no limit.)Set the number of seconds that a physical connection can
remain unused in the pool before the connection is closed.
maxIdleTime
-1 (Disables connection pooling.)Sets the maximum number of physical connections that the
pool can contain.
maxPoolSize
0 (Disables statement pooling.)Sets the total number of PreparedStatement objects that the
connection pool should cache.
maxStatements
-1 (The minPoolSize value is
ignored.)
Limits the number of physical connections that can be in the
free connection pool.
minPoolSize
Table 5 Operations on CLOB and BLOB Data
Default ValueDescriptionProperty Name
NoneSpecifies the LOB table for using BLOB columns.blobTableName
NoneSpecifies the LOB table for using CLOB columns.clobTableName
100Sets the number of data locators to be reserved for a process
that stores data in a LOB table.
reserveDataLocators
Table 6 Internationalization Properties
Default ValueDescriptionProperty Name
ISO88591_1Sets character-set mapping that corresponds to the SQL/MX
ISO88591 character set.
ISO88591
SJIS (which is shift-JIS, Japanese)Sets character-set mapping that corresponds to the SQL/MX
KANJI character set.
KANJI
ECU_KR (which is KS C 5601,ECU
encoding, Korean)
Sets character-set mapping that corresponds to the SQL/MX
KSC5601 character set.
KSC5601
NoneSets the language used for the error messages.language
FALSEDefines the behavior of the driver if the driver cannot translate
all or part of an SQL statement or SQL parameter.
translationVerification
Table 7 Logging and Tracing Properties
Default ValueDescriptionProperty Name
The name is defined by the
following pattern:
%h/t4sqlmx%u.log
Sets the name of the logging file for the Type 4 driver.T4LogFile
OFFSets the logging levels that control logging output for the Type
4 driver.
T4LogLevel
Table 8 Miscellaneous Client-Side Properties
Default ValueDescriptionProperty Name
NoneSpecifies the registered source name.description
NoneSpecifies the location of the properties file that contains
keyword-value pairs that specify property values for
configuring the Type 4 driver .
properties
Overview of the Type 4 Driver Properties 35