File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Resultset Exhausted

 
jaya kemmannu
Ranch Hand
Posts: 89
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Hi,

I am having "Exhausted Resultset" error in the below part of code. This error i ma facing only in production server but not in test server. What may be the Issue ?



Error Logs

Entered getLsaID method
Sql SELECT Query SELECT LSA_ID FROM NP_MAIN.NP_PORT_REQ_DTLS WHERE NP_TXN_ID=?
java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:388)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1515)
at com.np.sc.ProcessSCSYNV.getLsaID(ProcessSCSYNV.java:302)
at com.np.sc.ProcessSCSYNV.main(ProcessSCSYNV.java:103)
Exit getLsaID method
Entered getCurrentStateID method
Sql Select Query SELECT CURRENT_STATE_ID FROM NP_MAIN.NP_TN_DTLS WHERE TN= ? and NP_TXN_ID = ?
java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:388)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1515)
at com.np.sc.ProcessSCSYNV.getCurrentStateID(ProcessSCSYNV.java:376)
at com.np.sc.ProcessSCSYNV.main(ProcessSCSYNV.java:106)
Exit getCurrentStateID method


Regards,
Jay

 
Saif Asif
Ranch Hand
Posts: 440
Eclipse IDE Hibernate Linux
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Of the above lines of code , which one is

ProcessSCSYNV.java:376
 
jaya kemmannu
Ranch Hand
Posts: 89
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Hi Asif,

I have mentioned in the code part where error is being thrown.




Regards,
Jaya
 
Swastik Dey
Rancher
Posts: 1601
5
Android Java Java ME
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Make sure you do have records in the resultset before you retrieve the column value.

 
jaya kemmannu
Ranch Hand
Posts: 89
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Thanks Swastik. My query returned error !!. Now rectified.

Regards,
Jaya
 
Swastik Dey
Rancher
Posts: 1601
5
Android Java Java ME
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You are welcome.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic