OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Easy way to open an existing hsqldb file based database?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
linwei
Newbie
Newbie


Joined: 14 Nov 2005
Posts: 2

PostPosted: Mon Nov 14, 2005 2:38 pm    Post subject: Easy way to open an existing hsqldb file based database? Reply with quote

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
Back to top
View user's profile Send private message
linwei
Newbie
Newbie


Joined: 14 Nov 2005
Posts: 2

PostPosted: Wed Nov 16, 2005 5:26 pm    Post subject: Reply with quote

Anyboday want to give a comment? Thanks.
Back to top
View user's profile Send private message
Gilles B.
General User
General User


Joined: 13 Nov 2005
Posts: 23

PostPosted: Thu Nov 17, 2005 12:10 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group