[Solved] Clarification Split Data Base Class Path

Creating tables and queries
Post Reply
Dalke55
Posts: 25
Joined: Sat Jan 19, 2019 11:08 pm

[Solved] Clarification Split Data Base Class Path

Post by Dalke55 »

I have been using a split database currently Hsqldb 2.3.5. in the instructions to set up it states to remove the global class path. is this path removed and not added back in at all, for all split database folders?

Thank You!
Last edited by Dalke55 on Fri Nov 12, 2021 10:00 pm, edited 1 time in total.
Apache OpenOffice 4.1.6 Windows 10
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Clarification Split Data Base Class Path

Post by Villeroy »

Install this: viewtopic.php?f=21&t=77543
Open your split database.
Call macro FreeHSQLDB>FreeHSQLDB>Main
Click the connect button and select the *.script file of your database.
Click the driver button and select the hsqldb.jar to be used. The class path will be stored in the database document.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
UnklDonald418
Volunteer
Posts: 1550
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Clarification Split Data Base Class Path

Post by UnklDonald418 »

Most users do not need anything in the global Class Path.
The macro that runs each time a split database is opened, uses a private copy of hsqldb.jar in the driver sub-directory. If a copy of hsqldb.jar is located at a specified global ClassPath, Base will attempt to use that, creating a potential conflict. Plus there are security issues, ClassPath help warns "Java classes that are accessed through the classpath do not undergo a security check".
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Dalke55
Posts: 25
Joined: Sat Jan 19, 2019 11:08 pm

Re: Clarification Split Data Base Class Path

Post by Dalke55 »

Thank you both, this explains a lot as to some issues I have had duplicating my production DB.
Apache OpenOffice 4.1.6 Windows 10
Post Reply