- This topic has 2 replies, 3 voices, and was last updated 19 years, 11 months ago by
.
-
Posts
-
i just used DE on a hsqldb database. i then launched my app which also uses that hsqldb in standalone mode and it was still locked. i had to close eclipse, delete the lock file and restart.
i think you need to execute “SHUTDOWN COMPACT” command on the database before closing the connection in order to unlock it. can you make this automatic?
My approach has been that it is up to the JDBC implementation to take care of cleaning up resources. I would suggest that you execute the SHUTDOWN yourself from the SQLEditor. Yes, we could make this automatic, but it requires vendor-specific detection at runtime and special casing what is otherwise a very straightforward connection.close(). We can enter a request for this, but I doubt it will be given high-priority.
