data-source-type.pool.maxsize

The maximum number of connections in the connection pool. If the number of connections required exceeds the number of connections specified in data-source-type.cache.size, Essbase Studio Server opens temporary connections until the value specified in data-source-type.pool.maxsize is reached. As the number of connections required decreases, the temporary connections are destroyed.

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

The default for the maximum number of connections in the connection pool is 10.

See also data-source-type.cache.size.

Syntax

data-source-type.pool.maxsize=maximum size of the connection pool

Valid values for data-source-type are:

Examples by Data Source Type

Oracle.pool.maxsize=20

db2.pool.maxsize=20

sqlserver.pool.maxsize=20

mysql.pool.maxsize=20

netezza.pool.maxsize=20

obiee.pool.maxsize=10

teradata.pool.maxsize=20