Le 21/04/12 10:28, Ian Whitfield a écrit :
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
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
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: email@example.com
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
Impressum (Legal Info)
: 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