title: JDBC UnableToExecuteStatementException for creating table for testing
body: <p>I'm using <a href="http://wakandan.github.io/2015/09/21/setup-dropwizard-testing-for-dao.html" rel="nofollow noreferrer">http://wakandan.github.io/2015/09/21/setup-dropwizard-testing-for-dao.html</a> guide for testing dao</p>
  
  <p>I setup my <code>DataSourceFactory</code> as</p>
  
  <pre><code>DataSourceFactory dataSourceFactory = new DataSourceFactory();
  dataSourceFactory.setDriverClass( "org.h2.Driver" );
  dataSourceFactory.setUrl( "jdbc:h2:mem:test-%s;MODE=MySQL;TRACE_LEVEL_FILE=3;INIT=CREATE SCHEMA IF NOT EXISTS MY_SCHEMA" );
  dataSourceFactory.setUser( "sa" );
  dataSourceFactory.setPassword( "" );
  return dataSourceFactory;
  </code></pre>
  
  <p>My <code>sql</code> file looks like</p>
  
  <pre><code>USE my_schema;
  
  CREATE TABLE users (
      AutoId INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
      ...
  ) ENGINE = InnoDB, DEFAULT CHARSET = utf8;
  </code></pre>
  
  <p>I have used these sql before using <code>mysql -uroot my_schema &lt; 0001.sql</code> and so on and they work fine.</p>
  
  <p>Using </p>
  
  <p>USE my_schema;</p>
  
  <pre><code>handle.begin();
      handle.createScript(FixtureHelpers.fixture("schema/0001.sql"))
          .execute();
      //and so on
      handle.commit()
  </code></pre>
  
  <p>I get</p>
  
  <blockquote>
    <p>org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException:
    org.h2.jdbc.JdbcBatchUpdateException: Syntax error in SQL statement
    "CREATE TABLE MY_SCHEMA.USERS (   AUTOID INT UNSIGNED PRIMARY KEY
    AUTO_INCREMENT ... ) ENGINE = INNODB, DEFAULT CHARSET = UTF8 ";
    expected "USING, ,, )";</p>
  </blockquote>
  
  <p>What am I doing wrong?</p>