Hi :) Could Andreas notes be added into the new Faq easily? Would it fit neatly anywhere? http://wiki.documentfoundation.org/Faq#Base Regards from Tom :)
--- On Fri, 20/4/12, Andreas Säger <[email protected]> wrote: From: Andreas Säger <[email protected]> Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: [email protected] Date: Friday, 20 April, 2012, 13:57 Am 20.04.2012 10:48, Ian Whitfield wrote: > On 20/04/2012 01:18, Andreas Säger wrote: >> There are not many users who suffer from the limited capabilities of >> HSQL 1.8. >> A high risk of total data loss is the main reason why one must not use >> the embedded database. Getting an embedded database out of the jail is >> easy enough. > OK Andreas (or anyone else) - for those of us not so good at this how > about a detailed Tutorial on doing this?? > > Right here.... > 1) Download and extract the latest HSQLDB to some place. No installation required. 2) Point the "Class Path" setting in the LibreOffice Java options to hsqldb.jar in your subdirectory "lib". 3) Extract the database folder out of your embedded .odb. 4) Rename the files: properties, script, backup, data to: foo.properties, foo.script, foo.backup, foo.data where "foo" is just an arbitrary name. 5) Connect a new Base document to a JDBC data source with an URL like: jdbc:hsqldb:file:/path/to/extracted/database/foo;default_schema=true (the "foo" refers to the same database name I used as file name prefix) 6) Copy queries, forms and reports from the old embedded .odb to the new one. Slightly more details and links in: > http://user.services.openoffice.org/en/forum/viewtopic.php?f=61&t=46324&p=214069&hilit=hsqldb#p214049 For multi-user access you can start the hsqldb.jar in server mode and connect the .odb clients with something like jdbc:hsqldb:hsql://192.168.0.2/foo;default_schema=true -- For unsubscribe instructions 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 -- Unsubscribe instructions: 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/documentation/ All messages sent to this list will be publicly archived and cannot be deleted
