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+h...@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
