Re: HSQLDB Lock files

ibooij@xxxxxxxxx wrote:
Hi all,

I have a problem with HSQLDB not releasing its lock (.lck) file on
Windows. I'm using HSQLDB in stand-alone mode. When I close my desktop
application, the lock file is still there. If I then start the
application again it will just start normally most of the times, but
sometimes it will fail to start with the following exception:

java.sql.SQLException: The database is already in use by another
process: org.hsqldb.persist.NIOLockFile@890e4315[file =C:\Conclusion
Projects\BrandTestTool\brandtesttooldb.lck, exists=true, locked=false,
valid=false, fl =null]: java.lang.Exception: checkHeartbeat(): lock
file [C:\Conclusion Projects\BrandTestTool\brandtesttooldb.lck] is
presumably locked by another process.

I use shutdown=true in my JDBC connection string, so I was under the
impression that the database should get a shutdown command when it's
stopped. I had the feeling that perhaps I had to give HSQLDB some time
to shutdown, so I added a two-second wait before shutting down the VM,
but that wasn't helpful.

BTW, I'm using HSQLDB via Hibernate. I only have one Session in my
SessionFactory and I make sure that the shutdown thread is the only
thread accessing the Session.

Does anybody have an idea?

thanks for taking the time reading this message,
Ilja


I can not help you but I think you will get a faster answer by submitting this question to HSQLDB's Help Forum. Also you may want to search for similar problems in that forum. You will get the help of the authors.

http://sourceforge.net/forum/forum.php?forum_id=73674

--
Thanks in Advance... http://weconsultants.prophp.org
IchBin, Pocono Lake, Pa, USA http://ichbinquotations.awardspace.com
______________________________________________________________________
'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)
.