title: Create in-memory database with hibernate and load data into
body: <p>For testing issues, I would like to create an in-memory database. One of the tables should have content by default. How do I do this?
  I tried with the following configuration:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;!DOCTYPE hibernate-configuration PUBLIC
      "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
      "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"&gt;
  &lt;hibernate-configuration&gt;
  &lt;session-factory&gt;
      &lt;!-- Database connection settings --&gt;
      &lt;property name="connection.driver_class"&gt;org.h2.Driver&lt;/property&gt;
      &lt;property name="connection.url"&gt;jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;INIT=CREATE SCHEMA IF NOT EXISTS `test`;&lt;/property&gt;
      &lt;property name="connection.username"&gt;root&lt;/property&gt;
      &lt;property name="connection.password"&gt;root&lt;/property&gt;
      &lt;property name="hibernate.default_schema"&gt;test&lt;/property&gt;
      &lt;property name="connection.pool_size"&gt;10&lt;/property&gt;
      &lt;property name="hibernate.dialect"&gt;org.hibernate.dialect.H2Dialect&lt;/property&gt;
      &lt;property name="show_sql"&gt;true&lt;/property&gt;
      &lt;property name="hibernate.hbm2ddl.auto"&gt;create&lt;/property&gt;
      &lt;property name="hibernate.current_session_context_class"&gt;thread&lt;/property&gt;
      &lt;property name="hibernate.hbm2ddl.import_files"&gt;initial_data.sql&lt;/property&gt;
  &lt;/session-factory&gt;
  </code></pre>
  
  <p></p>
  
  <p>The file initial_data.sql is simple:</p>
  
  <pre><code>INSERT INTO test.email_template(template_id, description, subject, text, sender, reply_to)
  VALUES('1','Confirm','Your registration','Some content here','no_reply@mail.com',NULL);
  </code></pre>
  
  <p>But when I start the tests, I get the following error:</p>
  
  <pre><code>org.hibernate.tool.hbm2ddl.SchemaExport  : HHH000388: Unsuccessful:    VALUES('1','Confirm','Your registration','Some content here','no_reply@mail.com',NULL)
  2016-12-29 13:53:30.826 ERROR 6560 --- [ main]    org.hibernate.tool.hbm2ddl.SchemaExport  : Method is not allowed for a query. Use execute or executeQuery instead of executeUpdate; SQL statement:
  </code></pre>
  
  <p>What is wrong?</p>