I run 6.0.26 and have a very similar configuration on my container setting.
I removed validationQuery="SELECT 1 FROM DUAL" from mine, although I'm running connection pooling on mine. Are you attempting that at all with yours? I also have this attribute in mine. timeBetweenEvictionRunsMillis="-1" -----Original Message----- From: Anjib Mulepati [mailto:anji...@hotmail.com] Sent: Monday, February 27, 2012 9:28 AM To: Tomcat Users List Subject: Tomcat-DB Connection problem Hi All, I have DB and application in two different machine. My DB is Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production. And my applciation is in Tomcat 6.0.20. I have following in resource <Resource auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver" maxActive="20" maxIdle="10" maxWait="10000" name="jdbc/myApp" password="myPassword" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:oracle:thin:@//localhost:4001/myDB" username="myUser" validationQuery="SELECT 1 FROM DUAL" /> My problem is every time I restart DB machine I have to restart the tomcat to get application running. I am getting error java.sql.SQLRecoverableException: No more data to read from socket --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org