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

ChannelCreateTimeout

Use this attribute to determine the time limit in milliseconds to wait for a response to a channel create request.

The value used for the channel create timeout is determined by comparing the values set for the ChannelCreateTimeout, SQLQueryTimeoutMSec and SQLQueryTimeout connection attributes.

  • If ChannelCreateTimeout, SQLQueryTimeout and SQLQueryTimeoutMSec are non-zero, then the timeout used is the minimum value of these connection attributes.

  • If ChannelCreateTimeout is set to 0, then irrespective of the value of SQLQueryTimeout, channel timeout feature will be disabled and channel creation will be synchronous.

  • If ChannelCreateTimeout is set to a non-zero value and SQLQueryTimeout or SQLQueryTimeoutMSec are all set to 0, then the value of ChannelCreateTimeout is the timeout for channel creation.

Note:

If the timeout used is different than what is configured in the ChannelCreateTimeout connection attribute, TimesTen does not overwrite the value set for the ChannelCreateTimeout connection attribute.

See Choose SQL and PL/SQL Timeout Values in the Oracle TimesTen In-Memory Database Operations Guide for more information.

The timeout for channel create should not exceed the value specified for TTC_Timeout, which is a timeout for when the TimesTen client application waits for a result from the corresponding TimesTen Server process. See TTC_Timeout for details on this connection attribute.

Required Privilege

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

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is not supported in TimesTen Classic.

This attribute is supported in TimesTen Scaleout.

Setting

Set ChannelCreateTimeout as follows:

Where to set the attribute How the attribute is represented Setting

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

ChannelCreateTimeout

n - Time limit in milliseconds for how long to wait on a create channel request. The value of n can be any integer equal to or greater than 0. The default value is 30,000 milliseconds (30 seconds). If you set the value to 0, then the query does not time out.

Windows ODBC Data Source Administrator

Not applicable