is anyone knowing if hsql will support row update by usage of
rs.updateDate("columnName", new java.sql.Date(date.getTime()));
I get a
java.sql.SQLException: This function is not supported
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.notSupported(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.updateDate(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.updateDate(Unknown Source)
Maybe someone is knowing some details.
Cheers
Per
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi *,
is anyone knowing if hsql will support row update by usage of
rs.updateDate("columnName", new java.sql.Date(date.getTime()));
I get a
java.sql.SQLException: This function is not supported
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.notSupported(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.updateDate(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.updateDate(Unknown Source)
Maybe someone is knowing some details.
Cheers
Per
ResultSets are not updatable. You need to use an explicit prepared statement to update the row.
Thanks. Do you know if there are plans that this feature will be supported?
Cheers
Per