HSQLDB in memory DB producing local files ...

[lbrtchx]

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

 

[Andrew Thompson]

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.

 

[lbrtchx]

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

 

[Andrew Thompson]

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.

 

[Rogan Dawes]

Excellent. Glad you sorted it.


(double) Ick.

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

 

[lbrtchx]

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