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

For example, specify the value IGNORE as follows:
closeConnectionUponQueryTimeout=IGNORE
connectionTimeout Property
The connectionTimeout property sets the number of seconds a connection can be idle before the connection is physically closed by MXCS.
Set this property on a
DataSource object, ConnectionPoolDataSource object, or DriverManager object. For information about how to set
properties, see
How to Specify JDBC Type 4 Properties.
Data type: int
Units: seconds
Default: -1 (Use the
ConnTimeout value set on the MXCS server data source.)
Range: -1, 0 to 2147483647
Zero (0) specifies infinity as the timeout value.
A non-zero positive value overrides the value set on the MXCS server data source, if allowed by the MXCS settings. For more information,
see the SQL/MX Connectivity Server Manual.
A negative value is treated as -1.
For an example, consider this scenario. Even if a connection is not being used, it takes up resources. The application abandons connections;
that is, the application does not physically close a connection after the application finishes using the connection. However, you can configure the
connection to close itself after 300 seconds by setting the
connectionTimeout property. Then, when a connection is not referenced for 300
seconds, the connection automatically closes itself. In this example, the specification to set the
connectionTimeout property is:
connectionTimeout=300
dataSourceName Property
The dataSourceName property specifies the registered DataSource or ConnectionPoolDataSource name.
Set this property on the
DataSource object. For information about how to set the property value, see How to Specify JDBC Type 4 Properties.
Data type: String
Default: none
For example:
dataSourceName=myDataSource
description Property
The description property specifies the registered source name.
Set this property on a
DataSource object, ConnectionPoolDataSource object, or DriverManager object. For information about how to set
properties, see
How to Specify JDBC Type 4 Properties.
Data type: String
Default: none
The value can be any valid identifier.
executeBatchWithRowsAffected Property
The executeBatchWithRowsAffected property changes the behavior of java.sql.statement.executeBatch(). If the property is set to ON, the
java.sql.statement.executeBatch() returns an array that has the number of rowsaffected value for each java.sql.statement.addBatch(). If a
SQL operation fails, the entire batch operation rolls back. Set this property on a
DataSource object, ConnectionPoolDataSource object, or
DriverManager object. For information about how to set properties, see How to Specify JDBC Type 4 Properties.
Data type: String
Default: OFF
Values : ON or OFF
For example:
executeBatchWithRowsAffected=ON
initialPoolSize Property
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, For information about how to set the property value, see How to Specify JDBC Type 4 Properties.
The driver creates
n connections (where n is initialPoolSize) for each connection pool when the first connection is requested. For example, if