I had two junit tests using hsql to perform db operations. They were run using Ant 1.6.5 with hsql-1.8.0.2. When run on Linux 7.2, they worked fine. When run in Eclipse 3.1.1 (without using Ant), they also worked fine.

However, when they were run in ant 1.6.5 + Cygwin on Windows, the 2nd test always failed saying it couldn't acquire the lock as another process already had it.

Thanks to Campbell Boucher-Burnet, the problem can be resolved via the shutdown=true connection property. Details can be found here.

More on hsql connection properties can be found here.