EnableCancelTimeout
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
Purpose
Determines whether a cancel request that is sent by the driver as the result of a query timing out is subject to the same query timeout value as the statement it cancels.
Valid Values
true | false
Behavior
If set to true, the cancel request times out using the same timeout value,
in seconds, that is set for the statement it cancels. For example, if your application calls
Statement.setQueryTimeout(5) on a statement and that statement is
cancelled because its timeout value was exceeded, the driver sends a cancel request that
also will time out if its execution exceeds 5 seconds. If the cancel request times out,
because the server is down, for example, the driver throws an exception indicating that the
cancel request was timed out and the connection is no longer valid.
If set to false, the cancel request does not time out.
Default
false
Data Type
boolean