Forums Register Login

Closed Connection

+Pie Number of slices to send: Send
Hi,

In our aplication we are recieving the following closed connection exception randomly.
java.sql.SQLException: Closed Connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:976)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:883)
at weblogic.jdbc.pool.Connection.prepareStatement(Connection.java:393)

And this exception is thrown from different class. But when the same screen is accessed again then these exceptions arent thrown. This happens wehn the application uis loaded with more users.
We are using weblogic 7.0 and database Oracle 9i. JDK1.4 and JDBC version 9.0.2.0.0

Is this because of a connection breakage between the appl server and db server? Though when thse above error occurs, i could connect to database from sql plus.

I see an option in weblogic to test Reserved/Released connection; if we enable this option, will it have any adverse effect in the application performance > I believe this will validate the connection everytime the client request for a new conenction from the weblogic pool.
Please throw some light.

Thanks
vishy



+Pie Number of slices to send: Send
Please do not post the same question to multiple forums: CarefullyChooseOneForum

Let's continue the discussion in this duplicate thread.
catch it before it slithers away! Oh wait, it's a tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


Reply locked
This thread has been viewed 1205 times.
Similar Threads
JDBC Error - The Network Adapter could not establish the connection
Problem with WLS6.0 on Windows 2000 professional
StaleConnectionException
OracleConnection and Websphere
DB Error
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 04:29:06.