title: Best way to create schema in embedded HSQL database
body: <p>I'm currently using the following setup to create a schema in an embedded database before running my tests against it</p>
  
  <p>In my application context</p>
  
  <pre><code>&lt;jdbc:embedded-database id="dataSource" type="HSQL"&gt;
      &lt;jdbc:script location="classpath:createSchema.sql" /&gt;
  &lt;/jdbc:embedded-database&gt;
  </code></pre>
  
  <p>createSchema.sql</p>
  
  <pre><code>create schema ST_TEST AUTHORIZATION DBA;
  </code></pre>
  
  <p>hibernate properties</p>
  
  <pre><code>&lt;properties&gt;
      &lt;property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect" /&gt;
      &lt;property name="hibernate.default_schema" value="ST_TEST"/&gt;
      &lt;property name="hibernate.hbm2ddl.auto" value="create-drop" /&gt;
      &lt;property name="hibernate.show_sql" value="true" /&gt;
      &lt;property name="hibernate.use_sql_comments" value="true" /&gt;
      &lt;property name="hibernate.cache.use_second_level_cache" value="false" /&gt;
  &lt;/properties&gt;
  </code></pre>
  
  <p>My question is is this the best way to do this. Or can i use a different schema name in my properties? or set the schema name in the jdbc:embedded-database element</p>