Re: apache-tomcat-jdbc-1.0.4 Multiple Resources

[Filip Hanik - Dev Lists]

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