Open source software supply chain lighting plan, waiting for you>>>
java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError. java:113 )
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError. java:147 )
The reason for this error is that the resultset cursor pointer is out of the last element, which indicates that either the resultset set is empty , or the set has no elements to read . At this time, you call rs.get() to get the element, and an error will be reported
if (rs! = null) {
while (rs.next()) {
count = rs.getInt(1);
}
count = rs.getInt(1); //this will throw Exhausted resultset
}
Similar Posts:
- IO exception: socket read timed out always appears in Oracle program
- java.sql.SQLException: Fail to convert to internal
- How to Solve Java.sql.sqlexception: ora-02289: sequence does not exist
- [Solved] oracle.net.ns.NetException: Got minus one from a read call
- [Solved] JAVA:java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcodbcDrive
- Pytest @pytest.mark.parametrize Example
- Message: stale element reference: element is not attached to the page document error solution
- Occlusion problem of SVG Z-index layer
- The jdbc driver imported from idea into MySQL appears “Java. Lang. classnotfoundexception: com. Mysql. CJ. JDBC. Driver”
- Logstash output jdbc Error: java.lang.IllegalAccessError: tried to access class com.mysql.jdbc.EscapeProcessor from class com.mysql.jdbc.ConnectionImpl