TransactionTimeout

Use this attribute to specify the time limit in seconds for a user transaction to complete.

If a transaction times out, TimesTen returns an error indicating that either:

• TimesTen rolled back the transaction on behalf of the user, or

• The user must roll back the transaction.

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

Note:

• When a transaction timeout is provided, TimesTen behavior is on a best-effort basis. It is not possible to guarantee that the timeout will actually occur within the specified time.

• Transaction timeouts are honored during the active phases of the transaction. However, transactions do not timeout during non-active phases, such as commit, reclaim or in-doubt transaction recovery.

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 TransactionTimeout 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	TransactionTimeout	n - Time limit in seconds for a user transaction to complete. The value of n can be any integer equal to or greater than 0. The default value is 0, indicating that the transaction does not time out.
Windows ODBC Data Source Administrator	Not applicable