Quantcast

Connection Closed Issue

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Connection Closed Issue

Sharath Babu S S S
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@1c9e95a is 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 **********************************



Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: Connection Closed Issue

Propes, Barry L
You've closed a connection too early somewhere?

-----Original Message-----
From: Sharath Babu S S S [mailto:[hidden email]]
Sent: Wednesday, September 16, 2009 4:52 AM
To: [hidden email]
Subject: Connection Closed Issue

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@1c9e95a is 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 **********************************




---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re : Connection Closed Issue

chetoka
In reply to this post by Sharath Babu S S S
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 <[hidden email]> a écrit :

De: Sharath Babu S S S <[hidden email]>
Objet: Connection Closed Issue
À: [hidden email]
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@1c9e95a is 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 **********************************






Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Re : Connection Closed Issue

Gaurav Lohiya
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 <[hidden email]> 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 <[hidden email]>
> a écrit :
>
> De: Sharath Babu S S S <[hidden email]>
> Objet: Connection Closed Issue
> À: [hidden email]
> 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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Re : Connection Closed Issue

chetoka
Yes I defined the test query as well but it didn't fix the pb
The issue was fixed with the maxConnectionAge parameter

The exception was :

# com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

#

# ** BEGIN NESTED EXCEPTION **

#

# java.net.SocketException

# MESSAGE: Software caused connection abort: recv failed

#

# STACKTRACE:

#

# java.net.SocketException: Software caused connection abort: recv failed

# at java.net.SocketInputStream.socketRead0(Native Method)

# at java.net.SocketInputStream.read(Unknown Source)

My first config with c3p0 was :

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">

   <property name="driverClass"
 value="com.mysql.jdbc.Driver" />

   <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/mydb?relaxAutoCommit=true&amp;autoReconnect=true" />

   <property name="user" value="user" />

   <property name="password" value="0000" />

   <property name="initialPoolSize" value="5" />

   <property name="minPoolSize" value="5" />

   <property name="maxPoolSize" value="20" />

   <property name="checkoutTimeout" value="1000"/>

   <property name="acquireIncrement" value="1"/>

   <property name="testConnectionOnCheckin" value="true"/>

   <property name="testConnectionOnCheckout" value="true"/>

   <property name="preferredTestQuery" value="SELECT 1"/>

   <property name="idleConnectionTestPeriod"
 value="60"/>

</bean>

and now I added

<property name="maxConnectionAge"
 value="3600"/>

--- En date de : Mer 16.9.09, Gaurav Lohiya <[hidden email]> a écrit :

De: Gaurav Lohiya <[hidden email]>
Objet: Re: Re : Connection Closed Issue
À: "Tomcat Users List" <[hidden email]>
Date: Mercredi 16 Septembre 2009, 17h21

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 <[hidden email]> 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 <[hidden email]>
> a écrit :
>
> De: Sharath Babu S S S <[hidden email]>
> Objet: Connection Closed Issue
> À: [hidden email]
> 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



Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: Re : Connection Closed Issue

Sharath Babu S S S
In reply to this post by Gaurav Lohiya
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:[hidden email]]
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 <[hidden email]> 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 <[hidden email]>
> a écrit :
>
> De: Sharath Babu S S S <[hidden email]>
> Objet: Connection Closed Issue
> À: [hidden email]
> 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





---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Re : Connection Closed Issue

David Smith-2
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:[hidden email]]
> 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 <[hidden email]> 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 <[hidden email]>
>> a écrit :
>>
>> De: Sharath Babu S S S <[hidden email]>
>> Objet: Connection Closed Issue
>> À: [hidden email]
>> 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
>>
>>
>>    
>
>
>
> --
> Regards
> Lohiya Gaurav
>
>  


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Re : Connection Closed Issue

Juha Laiho
In reply to this post by Sharath Babu S S S
Could there be a firewall dropping inactive connections between the
production app.server and database? (and, naturally, no such firewall
between test env. app.server and database)
--
..Juha


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:[hidden email]]
> 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 <[hidden email]> 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 <[hidden email]>
>> a écrit :
>>
>> De: Sharath Babu S S S <[hidden email]>
>> Objet: Connection Closed Issue
>> À: [hidden email]
>> 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
>
>
>
>
>
> ------------------------------------------------------------------------
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Maximum Number of processes Exceeded

Sharath Babu S S S
In reply to this post by Gaurav Lohiya
 
Hi,
 
   We are using Tomcat Server and oracle database. After running for a while we are getting this error in the log files.
    Its taking both inactive and active processess. how to remove the inactive processess so that we dont have this error.
 
Debug: makeConnection(Database)

java.sql.SQLException: ORA-00020: maximum number of processes (300) exceeded

 

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)

        at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:294)

        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357)

        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)

        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

        at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

        at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)

        at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)

        at org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:84)

        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)

        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)

        at utils.ConnectionBroker.makeConnection(ConnectionBroker.java:256)

        at utils.ConnectionBroker.makeConnection(ConnectionBroker.java:76)

        at beans.PurgeProcess_T.run(PurgeProcess_T.java:166)




 
 
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 **********************************






---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Maximum Number of processes Exceeded

jasonb
Hi Sharath.

Can you tell us more about your environment?  For example:
- Your operating system brand and version.
- Your Tomcat version, where you initially got it, how you installed it.
- Your Java VM brand and version, and whether it is a JRE or JDK.
- Your Oracle version.
- Your Oracle JDBC driver version, where you got it, how you installed it.

Please give us as much of the above information as you can.

Thanks.
--
Jason Brittain


On Thu, Sep 17, 2009 at 7:22 PM, Sharath Babu S S S
<[hidden email]>wrote:

>
> Hi,
>
>   We are using Tomcat Server and oracle database. After running for a while
> we are getting this error in the log files.
>    Its taking both inactive and active processess. how to remove the
> inactive processess so that we dont have this error.
>
> Debug: makeConnection(Database)
>
> java.sql.SQLException: ORA-00020: maximum number of processes (300)
> exceeded
>
>
>
>        at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>
>        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
>
>        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
>
>        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
>
>        at
> oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:294)
>
>        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357)
>
>        at
> oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
>
>        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
>
>        at
> oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
>
>        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
>
>        at
> org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
>
>        at
> org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
>
>        at
> org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
>
>        at
> org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:84)
>
>        at
> org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
>
>        at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
>
>        at utils.ConnectionBroker.makeConnection(ConnectionBroker.java:256)
>
>        at utils.ConnectionBroker.makeConnection(ConnectionBroker.java:76)
>
>        at beans.PurgeProcess_T.run(PurgeProcess_T.java:166)
>
>
> With Regards............
> Sharat Babu Shravanam
>
>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: Maximum Number of processes Exceeded

George S.
In reply to this post by Sharath Babu S S S
Most likely, you're leaking connection handles or result sets.

A common error is storing them on the session. When the session times out
they are not necessarily garbage collected.

George Sexton
MH Software, Inc.
http://www.mhsoftware.com/
Voice: 303 438 9585
 

> -----Original Message-----
> From: Sharath Babu S S S [mailto:[hidden email]]
> Sent: Thursday, September 17, 2009 8:22 PM
> To: Tomcat Users List
> Subject: Maximum Number of processes Exceeded
>
>
> Hi,
>
>    We are using Tomcat Server and oracle database. After running for a
> while we are getting this error in the log files.
>     Its taking both inactive and active processess. how to remove the
> inactive processess so that we dont have this error.
>
> Debug: makeConnection(Database)
>
> java.sql.SQLException: ORA-00020: maximum number of processes (300)
> exceeded
>
>
>
>         at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:1
> 12)
>
>         at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
>
>         at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
>
>         at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
>
>         at
> oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthentic
> ate.java:294)
>
>         at
> oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357)
>
>         at
> oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:43
> 9)
>
>         at
> oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
>
>         at
> oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.
> java:35)
>
>         at
> oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
>
>         at
> org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(Dr
> iverConnectionFactory.java:38)
>
>         at
> org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(Poolab
> leConnectionFactory.java:294)
>
>         at
> org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(Generic
> ObjectPool.java:974)
>
>         at
> org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedO
> bjectPool.java:84)
>
>         at
> org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingData
> Source.java:96)
>
>         at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSour
> ce.java:880)
>
>         at
> utils.ConnectionBroker.makeConnection(ConnectionBroker.java:256)
>
>         at
> utils.ConnectionBroker.makeConnection(ConnectionBroker.java:76)
>
>         at beans.PurgeProcess_T.run(PurgeProcess_T.java:166)
>
>
>
>
>
>
> 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 **********************************
>
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Loading...