Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Yes, there are some pieces of information after some search:

  1. HSQLDB v.2+ supports disk-based tables (hsqldb.org) but Libreoffice Base uses v.1.8.

  2. There is some work to update Base driver (hsqldb.org).

  3. There are workarounds to bugs related to embedded "in-memory" HSQLDB v.1.8 (forum.openoffice.org).

  4. It seems, there is no easy solution for this problem. Only "close - open", using macro and some manual SQL commands maybe. I think, developers should warn users.

Summary: do not use embedded HSQL! Never!