Cache Group Requirements for Credentials
Because of the synchronous or asynchronous nature of some cache groups, TimesTen uses credentials set as follows:
-
When you connect to the TimesTen database to work with AWT or read-only cache groups, TimesTen Classic uses the credentials that are registered with the
ttCacheUidPwdSet
built-in procedure when connecting to the Oracle database on behalf of these cache groups. -
When you connect to the TimesTen database to work with SWT or user managed cache groups or passthrough operations, TimesTen Classic connects to the Oracle database using the current user's credentials provided in the connection string. This can be either the credentials stored in a wallet designated by the
UID
andPwdWallet
connection attributes or theUID
,PWD
, and
connection attributes.OraclePwd
-
When you are using dynamic load, the credentials used depend on if you are using connection pooling or not.
-
When
UseCacheConnPool
= 0 (the default), connection pooling is disabled. In this case, TimesTen Classic connects to the Oracle database using the current user's credentials provided in the connection string when performing a dynamic load request. -
When
UseCacheConnPool
= 2, connection pooling is enabled. In this case, TimesTen Classic connects to the Oracle database using the credentials that have been registered with thettCacheUidPwdSet
built-in procedure when performing a dynamic load request.
-