wood burning stoves 2.0
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

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

Joined: Oct 14, 2005
Posts: 19728

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.
Have you checked out Aspose?
subject: java.sql.SQLException: Closed Connection
jQuery in Action, 3rd edition