• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQLException Closed Resultset

 
kavitha lingam
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello
We are getting intermittent SQLException like Closed Resultset. We have Oracle 10g and using ojdbc14.jar. Find below the trace.


java.sql.SQLException: Closed Resultset: next
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
2)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:14
6)
at
oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:175
)
at
com.mchange.v2.c3p0.impl.NewProxyResultSet.next(NewProxyResultSet.java:2
859)
at
com.evant.em3.runtime.framework.domain.SqlExecutor.executeQuery(SqlExecu
tor.java:682)
at
com.evant.em3.runtime.framework.domain.SqlExecutor.executeQuery(SqlExecu
tor.java:628)


Some times we get a different trace

java.lang.NullPointerException
at
com.mchange.v2.c3p0.impl.NewProxyStatement.getResultSet(NewProxyStatemen
t.java:430)
at
com.evant.em3.runtime.framework.domain.SqlExecutor.executeQuery(SqlExecu
tor.java:664)
at
com.evant.em3.runtime.framework.domain.SqlExecutor.executeQuery(SqlExecu
tor.java:628)
at
com.evant.em3.runtime.framework.domaintostorage.repository.RelationalPer
sistenceStrategy.executeQuery(RelationalPersistenceStrategy.java:152)
at

Any guidance on fixing this would really help

Thanks
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34235
341
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you ruled out obvious causes yet such as the connection timing out or not always closing your resources?
 
Paul Clapham
Sheriff
Posts: 21001
31
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Another possibility is connections, or result sets, being accidentally shared between threads.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic