Apache OpenOffice (AOO) Bugzilla – Issue 73213
Integrate HSQLDB as Server Mode service (with native driver)
Last modified: 2015-03-06 14:58:28 UTC
One of the criticisms of OOo-Base, in comparison with MS-Access, is that the integrated hsqldb storage engine is only suitable for single-user work (whereas Access support multi-user databases, albeit through direct file access). Since OOo already ships with the hsqldb.jar included, this contains the hsqldb server. If the OpenOffice.org package set included a small application (with menu launcher) to launch instances of the hsqldb server (as a service on Windows, or daemon on *nix), this would be a wonderful way of providing SOHO users with a multi-user networked RDBMS system (avoiding the hassle of setting up and administrating MySQL/Postgresql etc.). Furthermore, OOo offers the most features with hsql so this is a good match (MySQL lacks relationships and the postgresql drivers are sub-par).
valid enhancement -> send further to the requirement team
set to 'new'
good enhancement. A first stage could be the adequat documentation to start a HSQLDB v1.8 server using the hsqldb.jar delivered with AOO, and then to connect AOO Base with it. However, the issue 55029 should be fully fixed to allow acceptance of such architecture.