title: h2 database test maven
body: <h2>Testing java application using H2 database 1.3.169</h2>
  <p>I'm testing my app in two different ways.</p>
  <ol>
  <li>In-memory database is created in a separate process from the application. I start H2 console and create database from scripts. All tests pass.</li>
  <li>In-memory database is created in the same process with the application when application start. All tests pass in Intellij IDEA 11.3. Using Maven 2 for testing some tests fail(create, update, delete for the one entity, expected dataset does not match with result). It seems as database wasn't updated. It doesn't happen every time, sometime build is successful. All tests are verified, all works on Oracle and DB2.</li>
  </ol>
  <p>What could be the cause of the problem?</p>