Thank's for the info @Howard i added suspectTimeout 60 removeAbandoned true removeAbandonedTimeout 180 timeBetweenEvictionRunsMillis 30000
2014-02-13 12:31 GMT-06:00 Howard W. Smith, Jr. <[email protected]>: > On Thu, Feb 13, 2014 at 10:21 AM, José Luis Cetina <[email protected] > >wrote: > > > <Resource id="any" type="DataSource"> > > JdbcDriver com.mysql.jdbc.Driver > > JdbcUrl ... > > UserName xxx > > Password xxx > > jtaManaged true > > initialSize=30 > > MaxActive=500 (my old value was 250) > > MaxIdle=50 > > MaxWait=90000 > > MaxWaitTime=90000 > > validationQuery=SELECT 1 > > testOnBorrow=true > > </Resource> > > > > compare your jdbc resource (above) with mine (below), and refer to tomcat > pool documentation. I think it will help if you use the extra config > parameters that I'm using below. > > <Resource id="jdbc/mcmsJta" type="javax.sql.DataSource"> > JdbcDriver org.apache.derby.jdbc.EmbeddedDriver > JdbcUrl jdbc:derby:D:/javadb/main;create=true > UserName ... > Password ... > JtaManaged true > jmxEnabled true > InitialSize 10 > MaxActive 30 > MaxIdle 20 > MaxWait 10000 > minIdle 10 > suspectTimeout 60 > removeAbandoned true > removeAbandonedTimeout 180 > timeBetweenEvictionRunsMillis 30000 > jdbcInterceptors=StatementCache(max=1024) > </Resource> > -- ------------------------------------------------------------------- *José Luis Cetina* -------------------------------------------------------------------
