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

Le 21/04/12 10:28, Ian Whitfield a écrit :

Hi Ian,

> On 20/04/2012 18:51, Alexander Thurgood wrote:
> > Check the permissions on your /software folder and also the permissions
> > on the hsqldb folder and any files in it. The jar file at least, needs
> > to have the executable bit set.

You only needed to check/change the permissions on this :

/home/ian/software/hsqldb-2.2.8/hsqldb/lib/hsqldb.jar

not the others ! Those other jar files you listed are the ones that come
with LO, and you shouldn't really be fiddling around with those.

> As I now want to try the external-linked way of running Base I selected
> to "Create a New Database'. Base opens but says .....
>
> a) I'm still using the embedded Database.
> b) And I get an error box that says ...  "The connection to the data
> source <DB Name> could not be established.
> The driver class 'org.hsqldb.jdbcDriver' coud not be loaded. The
> additional driver class path is
> 'vnd.sun.star.expand:$BRAND_BASE_DIR/program/classes/hsqldb.jar
> vnd.sun.star.expand:$BRAND_BASE_DIR/program/classes/sdbc_hsqldb.jar'.

1) Remove the links that you added to the Classpath parameter to :
/opt/libreoffice3.5/programs/classes/hsqldb.jar
/opt/libreoffice3.5/programs/classes/sdbc_hsqldb.jar

LO already knows where to find them. From what you describe as your
actions, you added them again to the classpath, and that is
possibly/probably what is causing LO to moan.

2) After removing the links to those files, restart LO.

3) Do not open your old ODB file in LO Base yet, i.e. the one you want
to migrate over to using the hsqldb2 engine.

4) Follow Andreas' instructions from point (3) onwards :

> 3) Extract the database folder out of your embedded .odb.

What Andreas means here is that you should make a copy of your existing
ODB database file, then unzip the copy. Although one can work directly
on the original ODB file if you know what you are doing, it would be
better I think in this case to work on a copy of that file.


> 4) Rename the files:
>  properties, script, backup, data
> to:
>  foo.properties, foo.script, foo.backup, foo.data
> where "foo" is just an arbitrary name.

This instruction should be clear, if not, please state what you don't
understand


> 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)

This too, seems clear to me, but if you have a question, please ask.


> 6) Copy queries, forms and reports from the old embedded .odb to the new one. 

This too, seems clear to me, but again, if uncertain, please ask.



Alex


-- 
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