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