IBM WebSphere Multichannel Bank Transformation Toolkit, Version 7.1

Configuring the Connection pool using JDBC Driver

About this task

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.

Table 1. Attribute descriptions for 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.

Table 2. Pool property description
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.


Feedback