java.sql.SQLException

Question

I am getting the following error:

java.sql.SQLException: Exhausted Resultset 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.driver.ScrollableResultSet.getOracleObject(ScrollableResultSet.java:655) at oracle.jdbc.driver.ScrollableResultSet.getFloat(ScrollableResultSet.java:828) at oracle.jdbc.driver.OracleResultSet.getFloat(OracleResultSet.java:1552) at website.web.InboxReader.NormalizeImp(InboxReader.java:625) at website.web.InboxReader.accessGmail(InboxReader.java:122) at website.web.InboxReader.main(InboxReader.java:51)

after these lines:

 ResultSet parentMessage = parentstmt.executeQuery("SELECT SUM(IMPORTANCE) AS IMPAVG FROM MAIL"); avgsum = parentMessage.getFloat("IMPAVG");

Am I not doing the above correctly?

Thanks!

possible duplicate of java.sql.SQLException: Exhausted Resultset — unholysampler
– unholysampler, Commented Nov 7, 2011 at 16:20

PTBG · Accepted Answer · 2011-11-07 16:21:26Z

2

try calling

parentMessage.next();

before trying to access SQL

answered Nov 7, 2011 at 16:21

PTBG

5952 gold badges21 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

java.sql.SQLException

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related