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 odbc.ini file in TimesTen Classic or in the database definition (.dbdef) file in TimesTen Scaleout	TTC_NoReconnectOnFailover	0 = Client reconnects to server after failover (default). 1 = Client does all the failover processing, but does not reconnect after failover.
Windows ODBC Data Source Administrator	No reconnect on failover field on the Oracle TimesTen Client DSN Setup dialog.	0 = Client reconnects to server after failover (default). 1 = Client does all the failover processing, but does not reconnect after failover.