data-source-type.cache.size

The internal cache of physical connections in the connection pool. The internal cache consists of physical connections that are always open. Some or all of the connections may be in use concurrently.

The data-source-type.cache.size property, together with the data-source-type.pool.maxsize property, controls connection pooling for data source connections. Connection pools allow several tasks to query the same data source connection concurrently.

The default size of the cache of connections is 5.

See also data-source-type.pool.maxsize.

Syntax

data-source-type.cache.size=number of physical connections in connection pool

Valid values for data-source-type are:

Oracle—oracle
IBM DB2—db2
Microsoft SQL Server—sqlserver
MySQL—mysql
Netezza—netezza
Oracle BI EE—obiee
Teradata—teradata

Examples by Data Source Type

oracle.cache.size=15

db2.cache.size=10

sqlserver.cache.size=15

mysql.cache.size=20

netezza.cache.size=25

obiee.cache.size=5

teradata.cache.size=15