Using the 1.0.4 version of the tomcat jdbc pool, I defined two resources. It
seems that the there is interaction between the two resource defined within
the jdbc pool. Upon initialization the following item is logged:
Jun 22, 2009 1:26:50 PM org.apache.tomcat.jdbc.pool.ConnectionPool init
WARNING: initialSize is larger than maxActive, setting initialSize to: 2
below are the resource declarations, one resource has an initialSize of 1
with a maxActive of 2, the other resource has an initialSize of 10 with a
maxActive of 100.
<Resource name="jdbc/DB1" auth="Container"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer"
url="jdbc:postgresql://127.0.0.1:5432/fjhawaii"
defaultAutoCommit="true"
removeAbandoned="true" removeAbandonedTimeout="60"
logAbandoned="true"
username="xxx" password="xxx" maxActive="100" maxIdle="100"
initalSize="10"
minIdle="0" maxWait="30000"
validationQuery="select 1" timeBetweenEvictionRunsMillis="5000"
minEvictableIdleTimeMillis="60000"
testOnBorrow="true" testOnReturn="false" testWhileIdle="false"
validationInterval="30000"/>
<Resource name="jdbc/DB2" auth="Container"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
url="jdbc:postgresql://10.1.1.191:5432/fjmreport"
defaultAutoCommit="true"
removeAbandoned="true" removeAbandonedTimeout="60"
logAbandoned="true"
username="xxx" password="xxx" maxActive="2" maxIdle="2"
initalSize="1"
minIdle="0" maxWait="30000"
validationQuery="select 1" timeBetweenEvictionRunsMillis="5000"
minEvictableIdleTimeMillis="60000"
testOnBorrow="true" testOnReturn="false" testWhileIdle="false"
validationInterval="30000"/>
Thanks,
Roger
--
View this message in context:
http://www.nabble.com/apache-tomcat-jdbc-1.0.4-Multiple-Resources-tp24154980p24154980.html
Sent from the Tomcat - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
