UseCacheConnPool

Enable the cache connection pool with the UseCacheConnPool connection attribute.

The cache connection pool can only be initiated from client/server applications and is used only for dynamic loads initiated for dynamic read-only cache groups.

To learn more about the cache connection pool, see Managing a Cache Connection Pool to the Oracle Database for Dynamic Load Requests in Oracle TimesTen In-Memory Database Cache Guide.

Required Privilege

No privilege is required to change the value of this attribute.

Setting

Set UseCacheConnPool 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	UseCacheConnPool	2 - Enabled: For each statement that requires a dynamic load from the Oracle database, the connections to Oracle are released after the load completes and the connection is returned to the cache connection pool. If a dynamic load is performed from a direct connection, the dynamic load proceeds as if the feature is not enabled. 0 (default) - Disabled: For each statement that requires a dynamic load from the Oracle database, the connections to Oracle are not closed by TimesTen after the load completes.
Windows ODBC Data Source Administrator	Not applicable