I am convinced somewhere in code, these connections are never returned to the pool (closed from the app's point of view) and that's why you have this problem . It's out of the pool's control what happens to the connection while it's out on loan. Unfortunately I've never had the chance to look into Hibernate or Spring, so it's hard to offer any help.
--David Sharath Babu S S S wrote: > 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 >> >> >> > > > > -- > Regards > Lohiya Gaurav > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
