tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gaurav Lohiya <gloh...@gmail.com>
Subject Re: Re : Connection Closed Issue
Date Wed, 16 Sep 2009 15:21:36 GMT
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 <kchetoua@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.Babu@solix.com>
> a écrit :
>
> De: Sharath Babu S S S <Sharath.Babu@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.T4CConnection@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.T4CConnection@1c9e95a is closed.
>
>     Debug: insertToAJArchiveLogDetails()
>
> java.sql.SQLException: Connection oracle.jdbc.driver.T4CConnection@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.T4CConnection@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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message