Easy way to open an existing hsqldb file based database?

linwei · Newbie Joined: 14 Nov 2005 Posts: 2

Hello,

We put a lot of expectations on openoffice2.0 would make accessing hsqldb easier than before( 1.4 ), since OOo2.0 acclaimed that hsqldb to be integrated as internal database.

We choose hsqldb as the data repositories and we have other java programms to store our data in hsqldb.

We are looking for some way to open and edit the database through OOo2.0. We managed to do it but we think it looks too complex:

1. First import hsqldb.jar ( version 1.8, from hsqldb.org ) into "PakageManager" as "My pakcages". The purpose for this step is to make the hsqldb jdbc driver could be found.

2. "File->new->Database->"Connect to an existing database". We have to choose "JDBC" because "hsqldb" doesn't show in the list as other database types;

3. In "Datasource URL", we have to type in "hsqldb:c:\......" manually, and in "JDBC river class", type in "org.hsqldb.jdbcDriver" manually.

My question: is there any easier way( as easy as connecingt to MS Access database ) to connect to file based hsql database?

Thanks a lot in advance.

Linwei

linwei · Newbie Joined: 14 Nov 2005 Posts: 2

Anyboday want to give a comment? Thanks.

Gilles B. · General User Joined: 13 Nov 2005 Posts: 23

Your way to connect to HDBC is right... Little complex for the first time but further uses are quite straitforward since all those parameters are memorized..

Anyhow, I have the same problem with using HSQL native database : OO uses also this database but both are managed different ways so the one embedded in OO is totally useless ! (in that sense, MS acces is still much more attractive )

Question is : is there a kind of roadmap we can trust wich shows a JDBC (and probably an ODBC) which can access .odb files and by what date ?

Applications using database are quite heavy to develop and initial choices are very important... thus, we have to rely on trusted evolutions before selecting components such as database, utility tools...

BTW, is there a way to "restore" a .odb file with using an SQL file? I tried to migrate from mysql and had to do it quite manually ... (no import command)

Gilles