Yes i have validation query specified. In developement we are having the same environment and settings there it is working fine without any issues. But in testing environment we are having this issue. Cannot figure it out why throught log files. One more exception we can find in log file is that "CONNECTION NEVER CLOSED". With Regards............ Sharat Babu Shravanam
________________________________ From: Gaurav Lohiya [mailto:gloh...@gmail.com] Sent: Wed 9/16/2009 8:21 AM To: Tomcat Users List Subject: Re: Re : Connection Closed Issue Do you have the validation query specified. I believe putting in the validation query should solve the problem. On Wed, Sep 16, 2009 at 11:17 AM, Chetouani <kchet...@yahoo.fr> wrote: > Hi, > > I had a similar problem. > I was using tomcat and mysql and configured a connection pool using dbcp. > The problem was that after some hours the application starts to throw an > exception. > The exception was : communication link failure > > The reason is that mysql is destroying the connectionz after some time (8 > hours by default) > and the connection pool is not aware of that > > I replaced dbcp by c3p0 and defined the maxConnectionAge to 3600s and the > problem was solved > > > --- En date de : Mer 16.9.09, Sharath Babu S S S <sharath.b...@solix.com> > a écrit : > > De: Sharath Babu S S S <sharath.b...@solix.com> > Objet: Connection Closed Issue > À: users@tomcat.apache.org > Date: Mercredi 16 Septembre 2009, 11h52 > > Hi all, > > we are using Tomcat server 5.5.20. Database is 9.0.28. > After starting tomcat and using our application after sometime we are > getting the following error: > > Can anyone suggest me, its really very urgent > > Thread 78: SQLException While Purging the Selected Data From Source Table > java.sql.SQLException: Connection > > oracle.jdbc.driver.t4cconnect...@1c9e95a is closed. for CONFIG 100019 For > RUN_ID 100063 > > Debug: AJArchiveLogDetails.java Exception Occured While Inserting Data to > AJArchiveLogDetails java.sql.SQLException: Connection oracle.jdbc.dr > > iver.t4cconnect...@1c9e95a is closed. > > Debug: insertToAJArchiveLogDetails() > > java.sql.SQLException: Connection oracle.jdbc.driver.t4cconnect...@1c9e95ais > closed. > > at > org.apache.tomcat.dbcp.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:354) > > at > org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:246) > > at > org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:302) > > at > beans.AJArchiveLogDetails.insertToAJArchiveLogDetails(AJArchiveLogDetails.java:177) > > at beans.PurgeProcess_T.run(PurgeProcess_T.java:281) > > Debug: PurgeProcess_T.java: run() Thread 78: Exception While Updating the > AJ_JOBS Table java.lang.Exception: java.sql.SQLException: Connection > > oracle.jdbc.driver.t4cconnect...@1c9e95a is closed. for CONFIG 100019 For > RUN_ID 100063 > > Debug: PurgeProcess_T.java: run() Thread 78: Exception Releasing Resources > java.sql.SQLException: Connection oracle.jdbc.driver.T4CConnection@ > > 1c9e95a is closed. for CONFIG 100019 For RUN_ID 100063 > > > With Regards............ > Sharat Babu Shravanam > > -------------------------------------------------------------------- > Byte and Switch Names Solix Technologies > One of the Top 10 Startups to Watch > > Read More at http://www.solix.com/top10startups > --------------------------------------------------------------------- > > > > > > > > **************** CAUTION - Disclaimer ***************** > > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended > solely for the use of the addressee(s). If you are not the intended > recipient, please notify the sender by e-mail and delete the original > message. Further, you are not to copy, disclose, or distribute this > e-mail or its contents to any other person and any such actions are > unlawful. This e-mail may contain viruses. Solix has taken every > reasonable precaution to minimize this risk, but is not liable for any > damage you may sustain as a result of any virus in this e-mail. You > should carry out your own virus checks before opening the e-mail or > attachment. Solix reserves the right to monitor and review the content > of all messages sent to or from this e-mail address. Messages sent to or > from this e-mail address may be stored on the Solix e-mail system. > > > ****End of Disclaimer ********************************** > > > > > > > -- Regards Lohiya Gaurav
--------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
