hello, I found from my thread dump that 80% of my thread are at the following stage, waiting to lock PoolableConnectionFactory. This is the cause of my Tomcat hanging! Do I need to reconfigure my server.xml?
<parameter> <name>maxIdle</name> <value>10</value> </parameter> <parameter> <name>maxActive</name> <value>150</value> </parameter> <parameter> <name>driverClassName</name> <value>oracle.jdbc.driver.OracleDriver</value> </parameter> <parameter> <name>maxWait</name> <value>10000</value> </parameter> <parameter> <name>removeAbandoned</name> <value>false</value> </parameter> <parameter> <name>removeAbandonedTimeout</name> <value>60</value> </parameter> <parameter> <name>logAbandoned</name> <value>true</value> </parameter> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>username</name> <value>nokia</value> </parameter> <parameter> <name>password</name> <value>pswpnokia</value> </parameter> <parameter> <name>validationQuery</name> <value>select count(*) from dual</value> </parameter> <parameter> <name>timeBetweenEvictionRunsMillis</name> <value>60000</value> </parameter> <parameter> <name>numTestsPerEvictionRun</name> <value>3</value> </parameter> <parameter> <name>minEvictableIdleTimeMillis</name> <value>120000</value> </parameter> Following is the extract from thread dump: "http80-Processor228" daemon prio=1 tid=0x085a94d0 nid=0x275b waiting for monitor entry [acdff000..acdff8d8] at org.apache.commons.dbcp.PoolableConnectionFactory.validateObject(PoolableConnectionFactory.java:316) - waiting to lock <0x4d107d78> (a org.apache.commons.dbcp.PoolableConnectionFactory) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518) __________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]