Thursday, February 16, 2012

dbcp connection pool configuration

<Resource name="jdbc/{ds}DataSource"
auth="Container"
description="Connection Pool Datasource to {ds} Repository"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.driver"
username="{user}"
password="{pwd}"
url="jdbc:mysql:{host}:{port}/{database}"
testOnBorrow="true"
validationQuery="SELECT 1"
maxActive="100"
minIdle="10"
maxWait="10000"
initialSize="10"/>