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

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