Am 01.03.2015 um 22:01 schrieb Jay Lozier: >> > What is the current backend for Base? > > I remember at one time is HSQL 1.8 but one could install a later > version. > > Jay > >
When you create a new database document without Java support, then you get a directory of flat dBase files handled by LibreOffice's insufficient SDBC driver for dBase. With Java support it will be an embedded HSQL 1.8 database which is more a caricature of a database because it is slow, unsafe and insecure. The problem is _not_ HSQL. The problem is the way how the backend is wrapped into the zip archive which constitutes the "Base document". It is easy enough to convert an embedded HSQLDB to a normal (external) database and use it with a recent and more capable version of HSQL. Current version is 2.3. On the OpenOffice user forum you can find several tutorials, scripts and macros. But you can also use HSQL 1.8 with an external database if that version fits your needs. Just do not use a self-contained database in a single file for anything but educational stuff, demos or small projects for a single user on a local machine with a sound backup strategy. Otherwise you can connect a Base document to any database you have a driver for (ADO, ODBC, JDBC). -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
