Re: [Hsqldb-user] Lock file still active after closing hibernate session

[Felix N. <fel...@sm...>]

"Fred Toussi" <fr...@us...> writes:

hello Fred,

> The sessions may have been closed, but the database is still open. When
> your application ends, you need to execute SHUTDOWN instead of
> CHECKPOINT. 
>
> The recommendation to use CHECKPOINT is most useful when batch processes
> such as unit tests are run and there is no explicit shutdown before the
> process termination.

>> 				Session session = sessionFactory.openSession();
>> 				Transaction tx = session.beginTransaction();
>> 				session.saveOrUpdate(prj); // prj is an instance of Project
>> 				tx.commit();
>> 				session.connection().createStatement().execute("CHECKPOINT");
>> 				session.close();

=> I cannot use SHUTDOWN at this point because then hibernate's
session.close() will fail.

The problem is: when deleting a project, the database connection from a
hibernate session may be left open. But how I can get this DB connection
outside of the hibernate session in order to issue a SHUTDOWN?

Is there some kind of default connection or an API to shutdown database
connections?

Thanks,
-- 
Felix Natter