title: Spring Testing with H2 db configuration
body: <p>I use Oracle in production environment and I would like to use H2 for testing. I can type;</p>
  
  <pre><code>&lt;jdbc:embedded-database id="dataSource"&gt;
    &lt;jdbc:script location="classpath:schema.sql"/&gt;
    &lt;jdbc:script location="classpath:test-data.sql"/&gt;
  &lt;/jdbc:embedded-database&gt;
  </code></pre>
  
  <p>so my tables and scripts are created automatically. But I cannot set URL value of this db. (For H2-Oracle compatibility I should add ;MODE=Oracle to url part)</p>
  
  <p>is there a way to achieve this goal?</p>
  
  <p>Or just an opposite solution;</p>
  
  <pre><code>&lt;bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"&gt;
      &lt;property name="driverClassName" value="org.h2.Driver"/&gt;
      &lt;property name="url" value="jdbc:h2:file:h2\db"/&gt;
      &lt;property name="username" value="sa"/&gt;
      &lt;property name="password" value=""/&gt;        
  &lt;/bean&gt;
  </code></pre>
  
  <p>in this time, I can edit URL part, but how can I load default test scripts (create and data sqls) to this datasource?</p>