Menu

Plans for support of updateDate and similiar

Per Newgro
2007-08-08
2014-01-19
  • Per Newgro

    Per Newgro - 2007-08-08

    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

     
    • Fred Toussi

      Fred Toussi - 2007-08-08

      ResultSets are not updatable. You need to use an explicit prepared statement to update the row.

       
    • Per Newgro

      Per Newgro - 2007-08-09

      Thanks. Do you know if there are plans that this feature will be supported?

      Cheers
      Per

       

Log in to post a comment.