[libreoffice-documentation] Fw: [libreoffice-users] Re: Problems importing an OO database into LO

[Tom Davies <tomdavies04@yahoo.co.uk>]

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 <villeroy@t-online.de> wrote:

From: Andreas Säger <villeroy@t-online.de>
Subject: [libreoffice-users] Re: Problems importing an OO database into LO
To: users@global.libreoffice.org
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: users+help@global.libreoffice.org
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 documentation+help@global.libreoffice.org
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