Anjib Mulepati <anji...@hotmail.com> schrieb:
>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 Hi Anjib. You are probably keeping one db connection open to handle your db stuff instead of using the pool for short running db tasks. If so, catch the exception and get a new connection from the pool. The pool will check the validity of the connection, before it hands the connection to you. Regards Felix > > > > > > >--------------------------------------------------------------------- >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
