Configuring connection pooling for database connections
You can configure connection pooling for your data source by defining a connection manager for it.
Example
The following example code uses the
connectionManager
element in the
server.xml file to define a connection pool for a data
source:<dataSource id="DefaultDataSource" jndiName="jdbc/example" jdbcDriverRef="DB2" >
<connectionManager maxPoolSize="10" minPoolSize="2"/>
<properties.db2.jcc databaseName="TESTDB"/>
</dataSource>
The server uses default values for any connection management settings that are not defined on the connection manager element. If a connection manager is not defined at all for a data source, the server uses default values for all of the settings.
Using thread local storage for connections can increase performance for applications on multi-threaded systems. See Tuning Liberty.You can define multiple data sources and associate each with a different connection manager. However, you cannot associate multiple data sources with a single connection manager.
For more information about the connectionManager
element, see Java Database Connectivity 4.1.