This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQLException Closed Resultset

 
kavitha lingam
Greenhorn
Posts: 1
  • 0
  • 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: 33694
316
Eclipse IDE Java VI Editor
  • 0
  • 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
Pie
Posts: 20187
26
MySQL Database
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Another possibility is connections, or result sets, being accidentally shared between threads.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic