[Solved] Base's HSQLDB database

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
Devlei
Posts: 12
Joined: Mon Nov 01, 2010 7:12 am

[Solved] Base's HSQLDB database

Post by Devlei »

I am new to Base, but see that when creating a new database it is an embedded database using the HSQL database engine. How do I connect to a HSQLDB database (that was created with HSQLDB Manager) from Base? Alternatively, how does Base store it's database cause I can't seem to find it to open it with HSQLDB Manager?
Last edited by Devlei on Fri Nov 05, 2010 4:58 pm, edited 1 time in total.
Open Office 3.2.1 running on Windows XP
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Base's HSQLDB database

Post by r4zoli »

You needs to add under Tools>Options>Java>Classes the hsqldb.jar from your OOo installation \...\Basis\Programs\classes\, to make external connection.
You can not reach OOo Base files from external database tools, without OOo running.

More on Base on wiki page: http://wiki.services.openoffice.org/wiki/Base
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
RPG
Volunteer
Posts: 2261
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: Base's HSQLDB database

Post by RPG »

Hello

see here

Romke
LibreOffice 24.8.5.2 on openSUSE Leap 15.6
Devlei
Posts: 12
Joined: Mon Nov 01, 2010 7:12 am

Re: Base's HSQLDB database

Post by Devlei »

To r4zoli and Romke

Your combined advice was spot on and together with the downloads from fredt article helped me sort the problem out.

Many thanks
Open Office 3.2.1 running on Windows XP
Post Reply