HSQLDB in memory DB producing local files ...

Thread view:

lbrtchx@hotmail.com - 29 Oct 2006 06:52 GMT

I am trying to use an in-memory only database table, but I see hsqldb
(ver. 1.8.7) producing three local files; namely:
.
mem1.lck
mem1.log
mem1.properties
.
I do not want for anything to be written to the local FS.
.
How could you avoid this?
.
Thanks
lbrtchx

Reply to this Message

Andrew Thompson - 29 Oct 2006 09:24 GMT

> I am trying to use an in-memory only database table, but I see hsqldb
> (ver. 1.8.7) producing three local files;

...

> I do not want for anything to be written to the local FS.
> .
> How could you avoid this?

HSQLDB also offers an applet* that works in an
untrusted (sandboxed) environment. ..So it must
have a way to avoid these 'local files'.

The only reason I mention/know is that I recently
downloaded it to see if I could get a light web start
version up and running**, and noticed it mentioned
it had a very small download applet (ick!) available.

* <http://www.hsqldb.org/doc/guide/apf.html#N12A6A>

** ...and no, I have been too busy doing other things
to actually attempt it yet.

Andrew T.

Reply to this Message

lbrtchx@hotmail.com - 29 Oct 2006 14:29 GMT

Actually Andrew, you may:
.
// __ set the DB to have an in-memory db declaring it in the driver and
protocol to be used
.
jdbc:hsqldb:mem:
.
http://www.hsqldb.org/doc/guide/ch04.html
.
// __ then use in-memory tables:
.
CREATE MEMORY TABLE MAINTABLE(MAINID INTEGER, ......);
.
http://www.hsqldb.org/doc/guide/ch05.html
.
I tested it and it seems to be working fine. What I don't like about
the applet is that it would require then a local server
.
Albretch

Reply to this Message

Andrew Thompson - 29 Oct 2006 16:02 GMT

> Actually Andrew, you may:
> .
> // __ set the DB to have an in-memory db declaring it in the driver and
> protocol to be used

...

> I tested it and it seems to be working fine.

Excellent. Glad you sorted it.

>...What I don't like about
> the applet is that it would require then a local server

(double) Ick.

Andrew T.

Reply to this Message

Rogan Dawes - 29 Oct 2006 16:45 GMT

>> Actually Andrew, you may:
>> .
[quoted text clipped - 11 lines]
>
> Andrew T.

I think you are mistaken here. The HSQLDB in memory mode does not
require a separate server process (although it CAN work that way). Read
up on "in process" configuration/deployment.

http://hsqldb.sourceforge.net/doc/guide/ch01.html#N101A8

Rogan

Reply to this Message

lbrtchx@hotmail.com - 29 Oct 2006 23:32 GMT

I think what Andrew and I have in mind is running hsqldb as
Memory-Only Databases:
.
http://hsqldb.sourceforge.net/doc/guide/ch01.html#N101CA
.
without out any vestige of a reference to a local file system
.
lbrtchx

Reply to this Message

HSQLDB in memory DB producing local files ...

Free Magazines