Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: Closed Connection

 
Shyam Hai
Ranch Hand
Posts: 68
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator




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
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Any code to show us?
 
Paul Clapham
Sheriff
Pie
Posts: 20958
31
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic