There is no harm using SHUTDOWN COMPACT each time, it just takes longer than
SHUTDOWN. Cached tables are saved properly with both commands.
I don't know why the org.hsqldb.Log thread is not terminated in your setup.
It should exit if the shutdown is completed successfully.
The whole logging framework is being revamped for the next version. We
might use a demon thread instead.
Fred Toussi
---------------
Bao-Long Nguyen-Trong wrote
I am using HSql as the database in a webapp environment (Tomcat, servlet,
JSP) and noticed that the org.hsqldb.Log thread is not set to be a deamon
thread. Is there a reason why?
The problem then is that the app server would not fully shutdown because of
this non daemon thread running. I am therefore forced to do a "SHUTDOWN
COMPACT" ("SHUTDOWN" doesn't do it) in order to get the thread to stop.
However, I am not sure of the side effects and whether the data (especially
cached tableds) will be saved properly.
Is there maybe a better way to work around the problem?
Thanks,
Bao-Long
-------------------------------------------------------
This sf.net email is sponsored by:
With Great Power, Comes Great Responsibility
Learn to use your power at OSDN's High Performance Computing Channel
http://hpc.devchannel.org/
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
