title: Issue with HSQL in memory database, LockAcquisitionException
body: <p>HSQL in memory database is giving CannotAcquireLockException when using multiple times in test cases. </p>
  
  <p>We are using:
  jdbc:hsqldb:mem:batchsqldb;sql.syntax_pgs=true</p>
  
  <p>this is giving CannotAcquireLockException which is intermittent. It comes half of the time. I have also tried hsqldb.lock_file=false; in connection url but did not work</p>