File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes java.sql.SQLException: Closed Connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "java.sql.SQLException: Closed Connection" Watch "java.sql.SQLException: Closed Connection" New topic
Author

java.sql.SQLException: Closed Connection

Shyam Hai
Ranch Hand

Joined: Feb 04, 2009
Posts: 68




I got this Exception.
how can i rectify.please...


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.pool.OraclePooledConnection.getConnection(OraclePooledConnection.java:300)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:302)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:268)
at com.dizlee.clistwat.util.ConnectionFactory.getTeleClubConnection(ConnectionFactory.java:166)
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
Any code to show us?
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18991
    
    8

You went to get a connection from the connection pool, but you got an exception. So check out these things: is there code which is taking connections but not returning them to the pool? Was the database server restarted, or did the database manager kill some sessions which corresponded to connections in the pool? Do you just not have enough connections in the pool to support the number of users you have now?

As you see, all kinds of things could be wrong.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: Closed Connection