i am using hsqldb memory database to test interaction with database (happy path tests, that some data can be entered and deleted), i do not conceive this as a unit tests merely as a integration test. for achieving that i need a tear down, so test are isolated. problem is that, tearing down does not work properly with hsqldb in memory database.
hsqldb sets up temporary file like mem.lck, mem.log. i try to delete them in my tearDown() method but it seems that sometimes filesystem is not quick enough to delete resources or file is locked, so for instance mem.lck is still there for the next test case which makes tests break.
has anybody experienced same problem and knows a solution for working with tearing down hsqldb memory database?