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.

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	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