1. Reference
  2. Connection Attributes
  3. General Use Connection Attributes
  4. General Connection Attributes
  5. SQLQueryTimeout

SQLQueryTimeout

Use this attribute to specify the time limit in seconds within which the database should execute SQL statements.

This attribute does not stop cache operations that are being processed on an Oracle database. This includes passthrough statements, flushing, manual loading, manual refreshing, synchronous writethrough, and propagating.

Both SQLQueryTimeout and SQLQueryTimeoutMSec attributes are internally mapped to one timeout value in milliseconds. If different values are specified for these attributes, only one value is retained.

The SQLQueryTimeout/SQLQueryTimeoutMsec value should be less than the TransactionTimeout value; the TransactionTimeout value should be less than the TTC_Timeout value.

For more details, see Choose SQL and PL/SQL Timeout Values in the Oracle TimesTen In-Memory Database Operations Guide.

Note:

  • When SQL query timeouts are used (SQLQueryTimeout or SQLQueryTimeoutMsec), TimesTen behavior is on a best-effort basis. It is not possible to guarantee that the timeout will actually occur within the specified time.

  • SQL query timeouts are honored during dynamic load unless the dynamic load requires a new connection to the Oracle database, in which case the connection is allowed to complete. If the connection completes successfully but the dynamic load times out, the connection will be retained.

Required Privilege

No privilege is required to change the value of this attribute.

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is supported in both TimesTen Classic and TimesTen Scaleout.

Setting

Set SQLQueryTimeout as follows:

Where to set the attribute How the attribute is represented Setting

C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen Classic or in the database definition (.dbdef) file in TimesTen Scaleout

SQLQueryTimeout

n - Time limit in seconds for which the database should execute SQL queries. The value of n can be any integer equal to or greater than 0. The default value is 0. A value of 0 indicates that the query does not time out.

Windows ODBC Data Source Administrator

Not applicable