Yes that was it, the message threw me off a bit since when I read to mean that the initialSize that I setup was larger, instead of the initialSize set by the default (which is 10) was larger.
Thanks, Roger Filip Hanik - Dev Lists wrote: > > most likely because you mispeled initialSize > > Filip > > rogerhb wrote: >> 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 >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > > -- View this message in context: http://www.nabble.com/apache-tomcat-jdbc-1.0.4-Multiple-Resources-tp24154980p24157131.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
