[youssef_samir]

Hi,

The edit table feature does not work with HSQLDB drivers. I get a message “The result set is not updatable.”. I am using the JDBC driver from HSQLDB package.

How can i find editable result set to work with HSQLDB

Thanks a lot
Youssef

[Haris Peco]

Youssef,

HSQLDb documentation claim that support updatable resultsets, but method ResultSet#updateObject is unsupported in latest stable relese (1.8.0.7)
MyEclipse can’t update row wtihout this method.
It looks that hsqldb support only syntax for updatable resultset, but not concrete update row.

Best
Peco

[PERRYALAIN]

Well, it’s a pity MyEclipse can’t do that, because DB Visualizer Personal can update data in a HSQLDB base, with the driver from HSQL of course.
Alain

[Author]

Posts