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 |
|
Seconds to wait for a client connect or disconnect request. Default is 20 seconds. |
Windows ODBC Data Source Administrator |
Not applicable |