Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

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 :


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

1) Remove the links that you added to the Classpath parameter to :

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.script, foo.backup,
where "foo" is just an arbitrary name.

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

5) Connect a new Base document to a JDBC data source with an URL like:
(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.


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.