1. Cache Guide
  2. Setting Up a Caching Infrastructure
  3. Configuring a TimesTen Database to Cache Oracle Database Data
  4. Cache Group Requirements for Credentials

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 and PwdWallet connection attributes or the UID, PWD, and OraclePwd connection attributes.

  • 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 the ttCacheUidPwdSet built-in procedure when performing a dynamic load request.