TTC_ConnectTimeout

The TTC_ConnectTimeout attribute specifies the maximum number of seconds the client waits for a SQLDriverConnect or SQLDisconnect request. It overrides the value of TTC_Timeout for those requests. Set the TTC_ConnectTimeout when you want connection requests to timeout with a different timeframe than the timeout provided for query requests. For example, you can set a longer timeout for connections if you know that it takes a longer time to connect, but set a shorter timeout for all other queries.

(You can use TTC_SqlTimeoutMS to override TTC_Timeout for all other requests, at a millisecond level.)

A value of 0 means there is no timeout. A negative value defers to the TTC_Timeout setting. As with TTC_Timeout, if the timeout is reached, the connection and the associated socket are closed without a call to SQLDisconnect.

TTC_ConnectTimeout can be set in either the client connection string or the client DSN.

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

Also see TTC_Timeout and TTC_SqlTimeoutMS.

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

TTC_ConnectTimeout

Seconds to wait for a client connect or disconnect request. Default is 20 seconds.

Windows ODBC Data Source Administrator

Not applicable