QueryTimeout
- 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
Sets the default query timeout (in seconds) for all statements created by a connection.
Valid Values
-1 | 0 | x
where:
- x
- is a positive integer that represents a number of seconds.
Behavior
If set to -1, the query timeout
functionality is disabled. The driver silently ignores calls to the
Statement.setQueryTimeout() method.
If set to 0, the default query timeout is
infinite (query does not time out).
If set to x, the driver uses the value as the default timeout for any statement that is created by the connection. To override the default timeout value set by this connection option, call the Statement.setQueryTimeout() method to set a timeout value for a particular statement.
Notes
- If x is specified, this property is ignored for HiveServer1 connections.
Default
0
Data Type
int