You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by rogerhb <ro...@niederland.com> on 2009/06/22 22:38:29 UTC
apache-tomcat-jdbc-1.0.4 Multiple Resources
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
Re: apache-tomcat-jdbc-1.0.4 Multiple Resources
Posted by rogerhb <ro...@niederland.com>.
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-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: apache-tomcat-jdbc-1.0.4 Multiple Resources
Posted by Filip Hanik - Dev Lists <de...@hanik.com>.
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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org