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

Data type: String
Default: OFF
Values : ON or OFF
For example: executeBatchWithRowsAffected=ON
initialPoolSize
The initialPoolSize property sets the initial connection pool size when connection pooling
is used with the Type 4 driver.
Set this property on a DataSource object or DriverManager object. This property is ignored
for connections made through the ConnectionPoolDataSource object. The driver creates n
connections (where n is initialPoolSize) for each connection pool when the first connection
is requested. For example, if initialPoolSize is set to 5 for a data source, the driver attempts
to create and pool five connections the first time the application calls the data source’s
getConnection() method.
Data type: int
Units: number of physical connections
Default: -1 (Do not create an initial connection pool.)
Range: -1 to maxPoolSize
• Any negative value is treated as -1.
• Values can be less than minPoolSize, but must not exceed maxPoolSize. If the specified
value is greater than maxPoolSize, the maxPoolSize property value is used.
For example: initialPoolSize=10
ISO88591
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. This property supports
English and other Western European languages. For more information, see Internationalization
(I18N) Support.
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object.
Data type: String
Default: ISO88591_1
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, Supported Encodings .
fetchBufferSize
The fetchBufferSize property limits the number of kilobytes to fetch from the server.
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object. For more information, see
“Specifying JDBC Type 4 Properties” (page 36).
Data type: int
Default: 512
Range: 0 through 2147483647
Zero and negative values are treated as default values.
Type 4 Driver Property Descriptions 41