In the client environment without data source support, to configure a connection pool that use JDBC DB Driver directly, you should provide the dbDriverName, dbUrl, dbUserName, dbPassword for connection pool.
The following is a connection pool configuration example that uses JDBC Driver.
<com.ibm.btt.bc.common.pool.ConnectionPoolImpl id="JDBCDAOPool" > <com.ibm.btt.bc.common.pool.JdbcConnectionConfig Injection="jdbcConfig" dbDriverName="COM.ibm.db2.jdbc.app.DB2Driver" dbUrl="jdbc:db2:journal鈥?> <com.ibm.btt.bc.common.pool.PoolProperty Injection="poolProperty" maxActive="10" /> </com.ibm.btt.bc.common.pool.ConnectionPoolImpl>
The following table illustrates all the properties that supported by JdbcConnectionConfig.
Attribute Name | Description |
---|---|
dbDriverName | Specifies the Driver name for DB connection. |
dbUrl | Specifies the URL for DB connection. |
dbUserName | Specifies the user name that used to log in the DB. |
dbPassword | Specifies the password of the user who want to log in DB. |
dbAutoCommit | To set the AutoCommit attribute of the DB connection. The default value is true. |
Besides the JDBC parameters, you should also set the pool properties; otherwise the default pool properties will be used.
The following table is the description of the pool properties.
Property Name | Default Value | Description |
---|---|---|
maxActive | 8 | Maximum number of connection that can be borrowed from the pool at one time. When non-positive, there is no limitation. |
maxIdle | 8 | Maximum number of connection that can sit idle in the pool at any time. |
minIdle | 0 | Minimum number of connection that can sit idle in the pool at any time. |
maxWait | -1 | Maximum wait on time (in millisecond) when borrow a connection from pool. Non-positive means wait on until the connection is obtained. |