Edit
HelloI can see that I have classpath'd both my Live and Test database locations.
I also know that this is highly NOT recommended
However, it may provide a solution in my restricted configuration (one server, one application)
For the sake of avoiding anyone else's unnecessary exertions, I will return to the topic when I have reviewed these new opportunities.
DavidRight, this works but impacts the Live instance, IOW I can't test an upgraded HSQLDB driver and leave the live instance as was.
Hence I need to find out how to apply driver versioning to the .odb package. IIRC there was a Macro solution for this, developed by Villeroy and others. Will have a look and BRB.
I have a mature AOO accounting application working with HSQLDB 2.3.0 and plan to upgrade to 2.3.4 as soon as possible. It's about time I got to grips with these upgrades anyway.
I can access the database using sqltool and sqlworkbench simply by installing hsqldb.jar and sqltool.jar in the appropriate directory.
However, "houston", I have a problem.
I cannot see how to do this for the OpenOffice Base client.
I have tried replacing the drivers in the drivers directory parallel to the database directory but this fails with a message indicating that the two driver levels do not match. This seems to indicate that I need to look inside the OO Base client.
I have read that it is possible to pack the .jar files into the .odb but the structure of that (zip container) offers no obvious clue. I think I need to do something else!
Any assistance very welcome
Thanks in Advance
David