tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rogerhb <ro...@niederland.com>
Subject apache-tomcat-jdbc-1.0.4 Multiple Resources
Date Mon, 22 Jun 2009 20:38:29 GMT

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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message