title: In-memory H2 database, insert scripts not persisting
body: <p>I'm tying to use H2 as an in-memory database for my unit testing.  I'm wiring everything together through Spring.  Everything <em>seems</em> to work fine.  The DB loads up, the ddl sql file runs, as does the dml sql (or so it seems).</p>
  
  <p>I can run a test that creates a record in the database, then retrieves and validates it was appropriately persisted.  So this tells me the ddl scripts ran fine.</p>
  
  <p>The issue is when I try to receive a record that was inserted via the dml script, i get nothing. </p>
  
  <p>I tried putting the same insert statement in the file twice and do indeed receive a unique constraint error, which tells me they are running...but for some reason not <em>persisting</em>.</p>
  
  <p>DDL:</p>
  
  <pre><code>DROP TABLE IF EXISTS `schema`.`region` ;CREATE  TABLE IF NOT EXISTS `schema`.`region` (
    `region_id` INT(11) NOT NULL ,
    `name` VARCHAR(56) NOT NULL ,
    `description` VARCHAR(512) NULL DEFAULT NULL ,
    PRIMARY KEY (`region_id`) );
  </code></pre>
  
  <p>DML:</p>
  
  <pre><code>INSERT INTO `schema`.`region` (`region_id`, `name`, `description`) VALUES (1001, 'TEST', 'TESTING');
  </code></pre>
  
  <p>URL:</p>
  
  <pre><code>jdbc:h2:file:db_test;MODE=MYSQL;INIT=create schema if not exists test_db\\;runscript from 'classpath:test_ddl.sql'\\;runscript from 'classpath:test_dml.sql'
  </code></pre>
  
  <p>Any help would be helpful.</p>
  
  <p>thanks </p>