Ask Your Question
2

Embedded Base DB with latest/later version of HSQLDB?

asked 2017-05-10 05:41:15 +0200

Tylluan gravatar image

Hi there,

I need an embedded DB (reason: single-user DB, shared via dropbox and used on Windows, Mac and Linux). I can't use the old version of HSQLDB because it doesn't support regexes. I can't use Firebird because I get errors on inserting data (setString errors and closed cursor errors - just nothing works at all).

Is there a way I can do this? I know about split database functionality, but I require an embedded database. I know I could create an SQLite DB and connect to that via ODBC but there are no (functioning) drivers I can find for this, and I'm not 100% certain that the base file would work across different platforms (and I'd rather not install ODBC drivers on all my PCs).

Is there any way I can do what I need? Thank you!

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
0

answered 2017-05-12 09:55:57 +0200

BlueBike gravatar image

I think that your way to go is splitting the DB the right way, as you already weakly suggested. Read through the articles and look the caption fully portable and self containing split DB.

Link example https://forum.openoffice.org/en/forum...

edit flag offensive delete link more

Comments

But he said he wants an embedded database.

EasyTrieve gravatar imageEasyTrieve ( 2017-05-12 18:20:24 +0200 )edit
0

answered 2017-05-11 07:29:10 +0200

Ratslinger gravatar image

Saw your question when posted but had no real answers. I've tested some drivers which work with SQLite, but only on Linux.

Looking for something else, ran across a post on another forum and after a brief once over it may be of some interest to you. Macro to extract and reconnect embedded HSQLDB.

Also toward the end of the post, FreeHSQLDB. It appears your options are limited. Hope this helps.

edit flag offensive delete link more
0

answered 2017-05-11 15:42:13 +0200

EasyTrieve gravatar image

I have not used it, but OpenOffice has an updated HSQLDB 2.3, and this supports regex.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-05-10 05:41:15 +0200

Seen: 552 times

Last updated: May 12 '17