ResultSet.cancelRowUpdates() throw Exception If no updates have been made

58 views
Skip to first unread message

prrvchr

unread,
Jun 23, 2022, 11:38:08 AMJun 23
to H2 Database

Hi,

H2 seems not to follow the JDBC specs and throws an exception when calling the ResultSet.cancelRowUpdates() method, if no updates have been made, with the following message:

org.h2.jdbc.JdbcSQLNonTransientException: No data is available [2000-212]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:497)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:223)
        at org.h2.message.DbException.get(DbException.java:199)
        at org.h2.message.DbException.get(DbException.java:188)
        at org.h2.jdbc.JdbcResultSet.cancelRowUpdates(JdbcResultSet.java:3437)
        at io.github.prrvchr.uno.sdbc.ResultSetBase.cancelRowUpdates(ResultSetBase.java:560)

This method as well as moveToInsertRow() is called by Base to ensure the availability of interfaces and to consider the ResultSet as updatable.

Thank you for your help.

Tested with H2 version 2.1.212

prrvchr

unread,
Jun 24, 2022, 6:53:17 AMJun 24
to H2 Database
I opened an issue because I don't have any solution to this problem...
Reply all
Reply to author
Forward
0 new messages