Client General Connection Attributes
Used only when you are connecting to a TimesTen server from a TimesTen client application.
In addition to the attributes detailed in this section, some database attributes and general connection attributes are also available for client connections or impact the behavior of the connection. These attributes are:
To view the value of a client attribute:
-
In ODBC 3.5, use the ODBC function
SQLGetConnectAttr
. To learn more about this function, see Attribute Support for ODBC 3.5 SQLSetConnectAttr and SQLGetConnectAttr in Oracle TimesTen In-Memory Database C Developer's Guide -
In ODBC 2.5, use the ODBC function
SQLGetConnectOption
. To learn more about this function, see Option support for ODBC 2.5 SQLSetConnectOption and SQLGetConnectOption section of the Oracle TimesTen In-Memory Database C Developer's Guide.
The client general connection attributes are described in detail next.
CipherSuites
The CipherSuites
attribute lists the cipher suite or suites that can be used, depending also on the client setting.
SSL_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256
SSL_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384
SSL_RSA_WITH_AES_128_CBC_SHA256
You must set this attribute for both the client and the server. For TLS to be used, the server and client settings must include at least one common suite.
See Configuration for TLS for Client/Server in Oracle TimesTen In-Memory Database Security Guide for more details.
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 TimesTen Classic but not supported in TimesTen Scaleout.Setting
Set CipherSuites
as follows.
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
CipherSuites |
Specify |
Windows ODBC Data Source Administrator |
CipherSuites field on the Oracle TimesTen Client DSN Setup dialog. |
Specify |
ChildServer
Identify the child server process with the ChildServer
connection attribute.
In a client/server environment, TimesTen can have multiple TimesTen child server processes to handle incoming requests from clients. You provide the ChildServer
connection attribute to identify a specific child server process for certain cache connection pool built-in procedures.
Each child server process is identified by a number assigned with the ChildServer=
n
connection attribute, where n
is a number ranging from 1 to the number of running child server processes. Once connected to the child server process, you can execute either the ttCacheConnPoolGet('current')
or ttCacheConnPoolApply
built-in procedures that are meant for a specific child server process.
For example, the following connects to the child server process identified as 1 and
applies the saved cache connection pool configuration to this child server process.
It does the same process for child server process 2 (given that
ServersPerDSN
=2).
Command> connect "DSN=cache1;ChildServer=1;"; Command> call ttCacheConnPoolApply; Command> disconnect; Command> connect "DSN=cache1;ChildServer=2;"; Command> call ttCacheConnPoolApply; Command> disconnect;
To learn more about the ClientServer
connection attribute, see Managing a Cache Connection Pool to the Oracle Database for Dynamic Load Requests in the Oracle TimesTen In-Memory Database Cache
Guide.
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 TimesTen Classic but not supported in TimesTen Scaleout.Setting
Set ChildServer
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
When you specify the |
Windows ODBC Data Source Administrator |
Not applicable |
Encryption
The Encryption
attribute specifies whether encryption is accepted, rejected, requested, or required for a client/server connection.
You must set this attribute for both the client and the server. Cipher settings must be the same on both the client and server, in most cases.
See Configuration for TLS for Client/Server in Oracle TimesTen In-Memory Database Security Guide for more details.
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 TimesTen Classic but not supported in TimesTen Scaleout.Setting
Set Encryption
as follows.
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
|
Windows ODBC Data Source Administrator |
Encryption field on the Oracle TimesTen Client DSN Setup dialog. |
|
SSLClientAuthentication
The SSLClientAuthentication
attribute specifies whether SSL client authentication is required (setting of 1) or not (setting of 0, the default). With client authentication, the server validates an identity presented by the client, and requires an identity (public/private key) in the client wallet.
Regardless of the client authentication setting, server authentication is performed, where the client validates the server.
You must set this attribute for both the client and the server. Regardless of the client authentication setting, server authentication is performed, where the client validates the server.
See Configuration for TLS for Client/Server in Oracle TimesTen In-Memory Database Security Guide for more details.
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 TimesTen Classic but not supported in TimesTen Scaleout.Setting
Set SSLClientAuthentication
as follows.
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
|
Windows ODBC Data Source Administrator |
SSL Client Authentication field on the Oracle TimesTen Client DSN Setup dialog. |
|
TCP_Port
When connecting to a TimesTen database using the TimesTen client and server, the TimesTen client requires the network address and the TCP port number of the computer running the TimesTen server.
The default TCP/IP port number is assumed for TCP_Port
unless you specify a value in the TTC_Server
connection attribute, in the ODBC connection string, or in the logical server definition. See TTC_Server or TTC_Server1 for more details.
If the TimesTen server is listening on a non-default port number, you must provide the port number in one of the following ways:
-
If using TimesTen Classic, you can specify the port number within the logical server definition, which contains the network address and port number pair. See Defining a Logical Server Name in Oracle TimesTen In-Memory Database Operations Guide for more information on defining a logical server.
-
You can specify the port number within the
TTC_Server
connection attribute using:TTC_SERVER=server_host_name/server_port;
-
You can specify the port number in the ODBC connection string.
"TTC_SERVER=server_host_name;TTC_SERVER_DSN=Server_DSN; TCP_PORT=server_port"
Or:
"DSN=Client_DSN;TCP_Port=server_port"
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 TCP_Port
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs |
|
Specify the port number where the server is listening. |
Windows ODBC Data Source Administrator and UNIX and Linux systems |
TCP_Port on the Oracle TimesTen Logical Server Name Setup dialog. |
Specify the port number where the server is listening. |
TCP_Port2, TCP_PortN
For TimesTen Classic, TimesTen uses this attribute to specify the port number to use if an automatic failover occurs. (This is unnecessary for TimesTen Scaleout.) See the description of TCP_Port
for details on setting the value of this attribute and associated attributes.
The default TCP/IP port number is assumed for TCP_Port2
and TCP_Port
N
unless you specify a value in the appropriate TTC_Server
N
connection attribute, in the ODBC connection string, or in the logical server definition. See TTC_Server or TTC_Server1 for more details.
Unspecified values for TCP_Port
N
inherit the value of TCP_PORT
(or TCP_PORT1
). For example, if TTC_Server2
is specified but TTC_Server_DSN2
and TCP_Port2
are not, then TTC_Server_DSN2
is set to the TTC_Server_DSN
value and TCP_Port2
is set to the TCP_Port
value.
See Using Automatic Client Failover in Oracle TimesTen In-Memory Database Operations Guide for more information on automatic client failover.
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 TCP_Port2, TCP_PortN
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs |
|
Specify the failover port number where the server should listen. |
Windows ODBC Data Source Administrator and UNIX and Linux systems |
Specify TCP_Port2, TCP_PortN in a connection string when also specifying a TTC_Server2, TTC_ServerN. |
Specify the failover port number where the server should listen. |
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 |
TTC_FailoverPortRange
Specifies a port range for the port that the automatic client failover thread listens on for failover notifications in an active/standby replication configuration. The failover configuration enables a client application to connect to a new active node automatically if there is a failure on the current node.
Specifying a port range helps accommodate firewalls between the client and server systems. By default, TimesTen uses a port chosen by the operating system.
See Using Automatic Client Failover in Oracle TimesTen In-Memory Database Operations Guide for more information on automatic client failover.
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_FailoverPortRange
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
Specify a lower value and an upper value for the port numbers in the format |
Windows ODBC Data Source Administrator |
Failover Port Range field on the Oracle TimesTen Client DSN Setup dialog. |
Specify a lower value and an upper value for the port numbers in the format |
TTC_NetMsgMaxBytes
The TTC_NetMsgMaxBytes
attribute specifies the maximum size in bytes of a client result set buffer.
The server stores a maximum number of bytes in the result set buffer size returned from a SELECT
statement. To improve the application’s performance, you can increase or decrease the maximum size in bytes of a client result set buffer with the TTC_NetMsgMaxBytes
connection attribute.
The buffer size can be set in terms of bytes or rows. The lower limit takes precedence. If you set one of them, it is recommended that you set the other also. It is suggested to decide first which maximum attribute you want to use and set it; then, set the other attribute to a value high enough to ensure that this value is not reached first.
The SELECT
statement will always return a complete result set even if filling the buffer takes multiple iterations. The SELECT
result is not limited by the TTC_NetMsgMaxBytes
attribute.
You can set the TTC_NetMsgMaxBytes
attribute in a connection string or DSN to serve as the value for any SELECT
statement on the connection.
Note:
Although the minimum possible setting value for theTTC_NetMsgMaxBytes
attribute is one byte, using this value would result in a buffer that is too small to contain the smallest row. For this reason, regardless of the value specified, the buffer is always sized to be large enough to contain at least one row.
See Sizing the Client Result Set Buffer in the Oracle TimesTen In-Memory Database Operations Guide for more information.
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_NetMsgMaxBytes
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
A positive integer value. The minimum size is 1. Default is 2097152 bytes (2MB). |
Windows ODBC Data Source Administrator |
Net Msg Max Bytes field on the Oracle TimesTen Client DSN Setup dialog. |
A positive integer value. The minimum size is 1. Default is 2097152 bytes (2MB). |
TTC_NetMsgMaxRows
The TTC_NetMsgMaxRows
attribute specifies the maximum number of rows stored in the client result set buffer.
Notes
The server stores a maximum number of rows in the result set buffer size returned from a SELECT
statement. To improve the application’s performance, you can increase or decrease the maximum number of rows of a client result set buffer with the TTC_NetMsgMaxRows
connection attribute.
- The
SELECT
statement will always return a complete result set even if filling the buffer takes multiple iterations. TheSELECT
result is not limited by theTTC_NetMsgMaxRows
attribute.
- The buffer size can be set in terms of rows or bytes. The lower limit takes precedence. If you set one of them, it is recommended that you set the other also. It is suggested to decide first which maximum attribute you want to use and set it; then, set the other attribute to a value high enough to ensure that this value is not reached first.
You can set the TTC_NetMsgMaxRows
attribute in a connection string
or DSN to serve as the value for any
SELECT
statement on the
connection.
See Sizing the Client Result Set Buffer in Oracle TimesTen In-Memory Database Operations Guide for more information.
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_NetMsgMaxRows
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
A positive integer value. The minimum is 1 row. Default is 8192 rows. |
Windows ODBC Data Source Administrator |
Net Msg Max Rows field on the Oracle TimesTen Client DSN Setup dialog. |
A positive integer value. The minimum is 1 row. Default is 8192 rows. |
TTC_NoReconnectOnFailover
Specifies whether the TimesTen client should not automatically reconnect to the server after a failover. If this is set to 1 (enabled), TimesTen is instructed to do all the usual client failover processing except for the reconnect. (For example, statement and connection handles are marked as invalid.) This is useful if the application does its own connection pooling or manages its own reconnection to the database after failover. The default value is 0 (reconnect).
You must configure automatic client failover for this option. See Client Connection Failover in Oracle TimesTen In-Memory Database Scaleout User's Guide for more information.
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_NoReconnectOnFailover
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
|
Windows ODBC Data Source Administrator |
No reconnect on failover field on the Oracle TimesTen Client DSN Setup dialog. |
|
TTC_Random_Selection
Specifies that the TimesTen client, if necessary, selects an alternative server from the list provided in TTC_ServerN
attribute settings. If the client cannot connect to the selected server, it keeps redirecting until it successfully connects to one of the listed servers. If the client cannot connect to any of the selected servers, TimesTen returns an error.
-
1
(default): Initially, the list of failover servers provided byTTC_ServerN
connection attributes is randomized. After which, the client selects sequentially from the randomized list for the initial connection and then for any client failover request. -
0
: Client selects the first server specified by theTTC_ServerN
connection attributes.
See Using Automatic Client Failover in Oracle TimesTen In-Memory Database Operations Guide for more information on automatic client failover.
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_Random_Selection
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
|
Windows ODBC Data Source Administrator |
Not applicable |
TTC_REDIRECT
For TimesTen Scaleout, TTC_REDIRECT
defines how a client is redirected. If this is set to 0 and the initial connection attempt to the desired data instance fails, then an error is returned and there are no further connection attempts. This does not affect subsequent failovers on that connection.
Automatic redirection: By default, this connection attribute is set to 1 so that a client connection is automatically redirected to any available data instance within the grid if the current host is busy or unavailable. The connection is redirected to the host with the fewest number of client connections.
Elements within a single replica set: If you want the client to connect to elements within a single replica set (because the data you are interested in is contained within this replica set), then set the TTC_REDIRECT
connection attribute to 0. Then, the client connects only to the host indicated by the DSN or to the host with the element in the same replica set. If the connection is rejected, then a connection error is returned.
The TTC_Redirect_Limit
attribute limits how many times the client is redirected. The number of hosts in your grid can be of a size that you want to limit the number of redirected client connection attempts for performance reasons. You can set the TTC_Redirect_Limit
connection attribute to the number of connection redirection attempts. For example, setting TTC_Redirect_Limit=10
limits the number of client connection redirection attempts to other hosts to 10 attempts. If the client does not connect within this number of attempts, a connection error is returned.
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_REDIRECT
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
1 (default) - redirect to any available data instance 0 - error if redirection to specified data instance fails |
Windows ODBC Data Source Administrator |
Not applicable |
TTC_Redirect_Limit
For TimesTen Scaleout, TTC_Redirect_Limit
limits how many times the client is redirected.
This is useful if the number of hosts in your grid is such that you want to limit the number of redirected client connection attempts for performance reasons.
For example, setting TTC_Redirect_Limit=10
limits the number of client connection redirection attempts to other hosts to 10 attempts. If the client does not connect within this number of attempts, a connection error is returned.
Note:
There is no setting for no limit, but you can set it to a very large integer.
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 TTC_Redirect_Limit
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems database definition ( |
|
Integer to limit how many times the client is redirected. The default is 1. |
Windows ODBC Data Source Administrator |
Not applicable |
TTC_Server or TTC_Server1
When connecting to a TimesTen database using the TimesTen client and server, the TimesTen client requires the specification of the network address and TCP port number of the computer running the TimesTen server. The network address provided can be a domain name server (DNS), host name or IP address.
Note:
If you are configuring for client failover, you may define more than one TimesTen server. See TTC_Server2, TTC_ServerN for more information.
If the TimesTen server is listening on a non-default port number, you must provide the port number in one of the following ways:
-
You can specify the port number within the
TTC_Server
connection attribute using:TTC_SERVER=server_host_name/server_port;
-
You can specify the port number in the ODBC connection string.
"TTC_SERVER=server_host_name;TTC_SERVER_DSN=Server_DSN; TCP_PORT=server_port"
Or:
"DSN=Client_DSN;TCP_Port=server_port"
-
If using TimesTen Classic, you can specify the port number within the logical server definition in the
ttconnect.ini
file.
See TCP_Port for more details.
Note that:
-
You can use either
TTC_Server
orTTC_Server1
for TimesTen Scaleout. If you define theTTC_Server
connection attribute, the value is used only for the initial connection. -
You can specify a logical server name for the
TTC_Server
attribute with TimesTen Classic that contains the network address and port number pair in thettconnect.ini
file. Once the logical server name is defined in thettconnect.ini
file, you can use that name as the value for theTTC_Server
attribute in a Client DSN definition. Multiple Client DSNs referencing the same computer that is running the TimesTen server can use the same logical server name for the value of theTTC_Server
attribute instead of having to specify repeatedly the same network address and port number within each of the Client DSNs. See Creating and Configuring a Logical Server Name on Linux and UNIX in the Oracle TimesTen In-Memory Database Operations Guide for more details.
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_Server
or TTC_Server1
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
Character string specifying the logical server. |
Windows ODBC Data Source Administrator |
Server Name or Network Address field on the Oracle TimesTen Client DSN Setup dialog. |
Character string specifying the logical server. |
TTC_Server2, TTC_ServerN
For TimesTen Classic, this attribute specifies the logical server name to use if an automatic failover occurs. See the description of TTC_Server or TTC_Server1
for details on setting the value of this attribute and associated attributes.
-
When using automatic client failover with an active standby pair replication scheme in TimesTen Classic, you can only define
TTC_Server2
. After which, the client alternately attempts to connect toTTC_Server
andTTC_Server2
until a connection succeeds or theTTC_TIMEOUT
attribute expires. -
For other types of automatic client failover, you can specify a list of failover servers with
TTC_Server
N
connection attributes whereN
>= 2
. TimesTen can iterate through this list of designated failover servers (as necessary) that you configured asTTC_Server2
,TTC_Server3
,TTC_Server4
, and so on. The maximum number of servers that the client can specify is 999.Note:
See TTC_Random_Selection on how TimesTen iterates through the list of designated failover servers.
Unspecified values for TTC_Server
N
, TTC_Server_DSN
N
, and TCP_Port
N
inherit the value of TTC_Server
(or equivalently, TTC_Server1
), TTC_Server_DSN
(or TTC_Server_DSN1
), and TCP_PORT
(or TCP_PORT1
), respectively. For example, if TTC_Server2
is specified but TTC_Server_DSN2
and TCP_Port2
are not, then TTC_Server_DSN2
is set to the TTC_Server_DSN
value and TCP_Port2
is set to the TCP_Port
value.
You should configure your failover servers sequentially. If you do skip a number when configuring your failover servers, then TimesTen automatically creates the missing definition and assigns it to the server identified by TTC_Server
. In this case, your client could fail over to the same server multiple times.
When using an active standby pair replication scheme for client failover, the TTC_Server or TTC_Server1 and TTC_Server2
connection attributes could potentially have the same setting if it is a virtual IP address. Virtual IP addresses can dynamically move to different hosts; thus, both connection attributes may have the same definition, but could be referencing distinct databases.
See Using Automatic Client Failover in Oracle TimesTen In-Memory Database Operations Guide for more information on automatic client failover.
Required Privilege
No privilege is required to change the value of this attributes.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in both TimesTen Classic and TimesTen Scaleout.Setting
Set TTC_Server2
or TTC_ServerN
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
Character string specifying the logical server to be used if an automatic failover occurs. |
Windows ODBC Data Source Administrator |
Failover Server Name or Network Address field on the Oracle TimesTen Client DSN Setup dialog configures the |
Character string specifying the logical server to be used if an automatic failover occurs. |
TTC_Server_DSN
The TTC_Server_DSN
attribute specifies a Server DSN on the computer running the TimesTen server.
More details on this topic can be found in Creating Client DSNs on a TimesTen Client System in the Oracle TimesTen In-Memory Database Operations Guide.
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_Server_DSN
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
Character string specifying the DSN that resides on the server. |
Windows ODBC Data Source Administrator |
Server DSN field on the Oracle TimesTen Client DSN Setup dialog. |
Character string specifying the DSN that resides on the server. |
TTC_Server_DSN2, TTC_Server_DSNn
For TimesTen Classic, this attribute specifies the Server DSN on the computer running the TimesTen server. (This is unnecessary for TimesTen Scaleout.) This is the Server DSN to be used if an automatic failover occurs. See the description of TTC_Server_DSN
for details on setting the value of this attribute and associated attributes.
If a failover occurs, if the client cannot connect to TTC_Server_DSN
or loses the connection to the DSN, it attempts to connect to TTC_Server_DSN2
or TTC_Server_DSN
n
.
Unspecified values for TTC_Server_DSN
n
inherit the value of TTC_Server_DSN
(or TTC_Server_DSN1
). For example, if TTC_Server2
is specified but TTC_Server_DSN2
and TCP_Port2
are not, then TTC_Server_DSN2
is set to the TTC_Server_DSN
value and TCP_Port2
is set to the TCP_Port
value.
See Using Automatic Client Failover in Oracle TimesTen In-Memory Database Operations Guide for more information on automatic client failover.
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_Server_DSN2
or TTC_Server_DSN
n
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or |
|
Character string specifying the DSN that resides on the server to be used if an automatic failover occurs. |
Windows ODBC Data Source Administrator |
Failover Server DSN field (only for |
Character string specifying the DSN that resides on the server to be used if an automatic failover occurs. |
TTC_SqlTimeoutMS
For client/server, this specifies the integer number of milliseconds the client will wait for a response to a request. It overrides the TTC_Timeout
connection attribute for any SQL execution request other than SQLDriverConnect
or SQLDisconnect
. A value of 0 means there is no timeout. A negative value defers to the TTC_Timeout
setting (which is in integer seconds).
(The timeout for SQLDriverConnect
and SQLDisconnect
is specified by setting the TimesTen TTC_ConnectTimeout
connection attribute.)
Also see TTC_Timeout and TTC_ConnectTimeout.
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 ScaleoutSetting
Set TTC_SqlTimeoutMS
as follows.
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
Integer milliseconds to wait for response from client. |
Windows ODBC Data Source Administrator |
N/A |
TTC_TCP_KEEPALIVE_INTVL_MS
The TTC_TCP_KEEPALIVE_INTVL_MS
attribute sets the time interval (in milliseconds) between subsequential probes.
By default, if the connection fails, TimesTen Scaleout sends the client connection to another active server. Part of the method to see if the connection is up or if it has failed is to check the TCP socket. When a TCP connection is started, a set of timers are associated with the connection. These timers indicate when TimesTen Scaleout checks the TCP socket to determine whether the connection is up or if it has failed.
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_TCP_KEEPALIVE_INTVL_MS
as follows.
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
A positive integer value. Default is |
Windows ODBC Data Source Administrator |
TCP KeepAlive Interval field on the Oracle TimesTen Client DSN Setup dialog. |
A positive integer value. Default is |
TTC_TCP_KEEPALIVE_PROBES
The TTC_TCP_KEEPALIVE_PROBES
attribute sets the number of unacknowledged probes to send before considering the connection as failed and notifying the client.
By default, if the connection fails, TimesTen Scaleout sends the client connection to another active server. Part of the method to see if the connection is up or if it has failed is to check the TCP socket. When a TCP connection is started, a set of timers are associated with the connection. These timers indicate when TimesTen Scaleout checks the TCP socket to determine whether the connection is up or if it has failed.
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_TCP_KEEPALIVE_PROBES
as follows.
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
A positive integer value. Default is |
Windows ODBC Data Source Administrator |
TCP KeepAlive Probes field on the Oracle TimesTen Client DSN Setup dialog. |
A positive integer value. Default is |
TTC_TCP_KEEPALIVE_TIME_MS
The TTC_TCP_KEEPALIVE_TIME_MS
attribute sets the duration time (in milliseconds) between the last data packet sent and the first probe.
By default, if the connection fails, TimesTen Scaleout sends the client connection to another active server. Part of the method to see if the connection is up or if it has failed is to check the TCP socket. When a TCP connection is started, a set of timers are associated with the connection. These timers indicate when TimesTen Scaleout checks the TCP socket to determine whether the connection is up or if it has failed.
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_TCP_KEEPALIVE_TIME_MS
as follows.
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
A positive integer value. Default is |
Windows ODBC Data Source Administrator |
TCP KeepAlive Time field on the Oracle TimesTen Client DSN Setup dialog. |
A positive integer value. Default is |
TTC_Timeout
The TTC_Timeout
attribute sets a maximum time limit, in seconds, for a network operation that is completed by using the TimesTen client and server. The TTC_Timeout
attribute also determines the maximum number of seconds a TimesTen client application waits for the result from the corresponding TimesTen server process before timing out. For example, if the Client application is running long queries, you may want to increase the timeout interval.
The operating systemselect()
call on the client side of a client/server connection uses the value of TTC_Timeout
. The SQLExecute()
and OCIStmtExecute()
functions do not.
A value of 0 indicates that client/server operations should not timeout. If this attribute is not set, the default timeout period is 60 seconds. The maximum timeout period is 99,999 seconds. Upon timeout, the operation is interrupted, the Client application receives a timeout error and the connection is terminated and socket closed (without a call to SQLDisconnect
).
For active standby pair failover scenarios, the minimum value is 60 seconds.
The timeout value can be set after establishing a connection by calling the ttIsql clienttimeout
command. When the query timeout is set after establishing a connection to the database, the client driver returns an error if the network timeout value is greater than 0, and the query timeout value greater than or equal to the network timeout value. The SQLState
is set to S1000.
This attribute is not supported (the setting ignored) when shared memory is used for client/server inter-process communication.
See Choose SQL and PL/SQL Timeout Values in Oracle TimesTen In-Memory Database Operations
Guide for information about the relationship between TTC_Timeout
, SQLQueryTimeout
, and PLSQL_TIMEOUT
.
TTC_Timeout
can be overridden for connect and disconnect requests by TTC_ConnectTimeout
and for all other SQL execution requests by TTC_SqlTimeoutMS
(at millisecond level). See TTC_ConnectTimeout and TTC_SqlTimeoutMS.
The SQLQueryTimeout
/SQLQueryTimeoutMsec
value should be less than the TransactionTimeout
value; the TransactionTimeout
value should be less than the TTC_Timeout
value.
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_Timeout
as follows.
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
A value between 0 and 99999 that represents the number of seconds that the TimesTen client waits for an operation to complete before timing out. (The default value is |
Windows ODBC Data Source Administrator |
Network Timeout field on the Oracle TimesTen Client DSN Setup dialog. |
A value between 0 and 99999 that represents the number of seconds that the TimesTen client waits for an operation to complete before timing out. (The default value is |
Wallet
The Wallet
attribute specifies the fully qualified directory path name, where you placed the certificates that you generated (preferably the same directory path as on the client). There is no default location. If you specify a relative path, it is relative to the timesten_home
/info
directory.
You must set this attribute for both the client and the server. You must set the same path on both the client and server.
See Configuration for TLS for Client/Server in Oracle TimesTen In-Memory Database Security Guide for more details.
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 Wallet
as follows.
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
A fully qualified directory path name (no default). |
Windows ODBC Data Source Administrator |
Wallet field on the Oracle TimesTen Client DSN Setup dialog. |
A fully qualified directory path name (no default). |