Thursday August 31, 2006 HSQLDB read only from Open Office via JDBC
Tried to open an existing hsqldb 1.8.x database from Open Office 2.0 using JDBC. I was unable to edit any of the tables. Turns out this is a known bug documented here:
http://www.openoffice.org/issues/show_bug.cgi?id=55029
The suggested workaround did fix the problem. Just add the following to the end of the JDBC connection url (don't forget the semicolon at the start):
;default_schema=true
You would think they would have better support for HSQLDB, since it is their internal database format, but I guess not.
Posted by rickg ( Aug 31 2006, 04:42:21 AM PDT ) Permalink Comments [0]