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

connectionTimeout
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.
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 HP NonStop Connectivity Server Manual
for SQL/MX Release 3.2.1.
• 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
The dataSourceName property specifies the registered DataSource or
ConnectionPoolDataSource name.
Set this property on the DataSource object.
Data type: String
Default: none
For example: dataSourceName=myDataSource
description
The description property specifies the registered source name.
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object.
Data type: String
Default: none
The value can be any valid identifier.
executeBatchWithRowsAffected
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.
40 Type 4 Driver Properties