File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Performance and the fly likes Closed Connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » Performance
Reply locked New topic

Closed Connection

Viswa Sethu
Ranch Hand

Joined: Nov 01, 2007
Posts: 31

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

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

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.


Ulf Dittmer

Joined: Mar 22, 2005
Posts: 39544
Please do not post the same question to multiple forums: CarefullyChooseOneForum

Let's continue the discussion in this duplicate thread.

Ping & DNS - updated with new look and Ping home screen widget
jQuery in Action, 2nd edition
subject: Closed Connection
Similar Threads
Problem with WLS6.0 on Windows 2000 professional
JDBC Error - The Network Adapter could not establish the connection
OracleConnection and Websphere
Closed Connection