Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: Cursor is closed

 
Kaustubh Dasgupta
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am returning a ref cursor from my oracle procedure and trying to get the data in my DAO class. But I am getting the following error:

[2/1/07 18:38:41:766 IST] 0000003d SystemErr R java.sql.SQLException: Cursor is closed.

at oracle.jdbc.driver.T4CResultSetAccessor.getCursor(T4CResultSetAccessor.java:323)

at oracle.jdbc.driver.ResultSetAccessor.getObject(ResultSetAccessor.java:85)

at oracle.jdbc.driver.OracleCallableStatement.getObject(OracleCallableStatement.java:1401)

at com.ibm.ws.rsadapter.jdbc.WSJdbcCallableStatement.getObject(WSJdbcCallableStatement.java:443)

at com.harcourt.elearning.services.reporting.persistence.dao.classsummaryreport.ClassSummaryReportDAO.generateReport

Can any one help.

Thanks in advance.

Kaustubh
 
Srikanth Basa
Ranch Hand
Posts: 241
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Its hard to conclude the reason without looking at the source.

Check thislink
 
Muhammad Saifuddin
Ranch Hand
Posts: 1324
Android Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
where you are closing the cursor remove that line. might be it works
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic