title: HSQLDB + JUnit + Hibernate: java.sql.SQLException: invalid schema name
body: <p>I want to run a test with JUnit and Hibernate an in-memory database HSQLDB, but when the method is trying to commit the changes to the DB, this exception appears: (No Spring framework)</p>
  
  <pre><code>Caused by: java.sql.SQLException: invalid schema name: SRH in statement [select liquidacio0_.idLiquidacion as idLiquid1_180_0_, liquidacio0_.fkEstado as fkEstado180_0_, liquidacio0_.FECHA_LIQ as FECHA3_180_0_, liquidacio0_.DIAS_LIQUIDAR as DIAS4_180_0_, liquidacio0_.MES_DIAS as MES5_180_0_, liquidacio0_.MES_LIQUIDACION as MES6_180_0_, liquidacio0_.LIQUIDACION_TVAC as LIQUIDAC7_180_0_, liquidacio0_.FECHA_ESTADO as FECHA8_180_0_, liquidacio0_.fkSolicitud as fkSolici9_180_0_, liquidacio0_.idTvac as idTvac180_0_, liquidacio0_.NUMLIQ as NUMLIQ180_0_, liquidacio0_.legajo as legajo180_0_, liquidacio0_.periodo as periodo180_0_ from srh.srh_liquidacion liquidacio0_ where liquidacio0_.idLiquidacion=?]
  at org.hsqldb.jdbc.Util.throwError(Unknown Source)
  at org.hsqldb.jdbc.jdbcPreparedStatement.&lt;init&gt;(Unknown Source)
  at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
  at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
  at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
  at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
  at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
  at org.hibernate.loader.Loader.doQuery(Loader.java:673)
  at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
  at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)
  </code></pre>
  
  <p>The exception occurs here:</p>
  
  <pre><code>sesionActiva.getTransaction().commit();
  </code></pre>
  
  <p>My hibernateTest.cfg.xml:</p>
  
  <pre><code>  &lt;hibernate-configuration&gt;
      &lt;session-factory&gt;
  
      &lt;!-- Database connection settings --&gt;
      &lt;property name="connection.driver_class"&gt;org.hsqldb.jdbcDriver&lt;/property&gt;
      &lt;property name="connection.url"&gt;jdbc:hsqldb:mem:testdb&lt;/property&gt;
      &lt;property name="connection.username"&gt;sa&lt;/property&gt;
      &lt;property name="connection.password"&gt;&lt;/property&gt;
      &lt;!--&lt;property name="hibernate.default_schema"&gt;srh&lt;/property&gt;--&gt;
  
      &lt;!-- JDBC connection pool (use the built-in) --&gt;
      &lt;property name="connection.pool_size"&gt;10&lt;/property&gt;
  
      &lt;!-- SQL dialect --&gt;
      &lt;property name="dialect"&gt;org.hibernate.dialect.HSQLDialect&lt;/property&gt;
  
      &lt;!-- Enable Hibernate's automatic session context management --&gt;
      &lt;property name="current_session_context_class"&gt;thread&lt;/property&gt;
  
      &lt;!-- Disable the second-level cache  --&gt;
      &lt;property name="cache.provider_class"&gt;org.hibernate.cache.NoCacheProvider&lt;/property&gt;
  
      &lt;property name="show_sql"&gt;true&lt;/property&gt;
  
      &lt;property name="hibernate.hbm2ddl.auto"&gt;update&lt;/property&gt;
  
      &lt;mapping resource="pkgClasesDeNegocio/pkgAdministracionNovedadAsistencia/Liquidacion.hbm.xml"/&gt;
       //And others
  
      &lt;/session-factory&gt;
    &lt;/hibernate-configuration&gt;
  </code></pre>
  
  <p>My Liquidacion.hbm.xml:</p>
  
  <pre><code>&lt;hibernate-mapping&gt;
  &lt;class catalog="srh" name="pkgClasesDeNegocio.pkgAdministracionNovedadAsistencia.Liquidacion" table="srh_liquidacion"&gt;
      &lt;id name="idLiquidacion" type="java.lang.Integer"&gt;
          &lt;column name="idLiquidacion"/&gt;
          &lt;generator class="identity"/&gt;
      &lt;/id&gt;
      &lt;many-to-one class="pkgClasesDeNegocio.pkgAdministracionNovedadAsistencia.Estado" lazy="false" fetch="select" name="estado"&gt;
          &lt;column name="fkEstado" not-null="true"/&gt;
      &lt;/many-to-one&gt;
      &lt;property name="fechaLiquidacion" type="date"&gt;
          &lt;column length="10" name="FECHA_LIQ"/&gt;
      &lt;/property&gt;
      &lt;property name="cantDiasALiquidar"&gt;
          &lt;column name="DIAS_LIQUIDAR"/&gt;
      &lt;/property&gt;
      &lt;property name="mesDeDias" type="string"&gt;
          &lt;column length="50" name="MES_DIAS"/&gt;
      &lt;/property&gt;    
      &lt;property name="mesDeLiquidacion" type="string"&gt;
          &lt;column length="50" name="MES_LIQUIDACION"/&gt;
      &lt;/property&gt;
      &lt;property name="fechaLiquidacionTvac" type="string"&gt;
          &lt;column length="50" name="LIQUIDACION_TVAC"/&gt;
      &lt;/property&gt;
      &lt;property name="fechaEstado" type="date"&gt;
          &lt;column length="10" name="FECHA_ESTADO"/&gt;
      &lt;/property&gt;
      &lt;many-to-one class="pkgClasesDeNegocio.pkgAdministracionNovedadAsistencia.SolicitudVacaciones" lazy="false" fetch="select" name="solicitud"&gt;
          &lt;column name="fkSolicitud" not-null="true"/&gt;
      &lt;/many-to-one&gt;
      &lt;property name="idTvac"&gt;
          &lt;column name="idTvac"/&gt;
      &lt;/property&gt;
      &lt;property name="nroLiquidacion"&gt;
          &lt;column name="NUMLIQ"/&gt;
      &lt;/property&gt;
      &lt;property name="legajo"&gt;
          &lt;column name="legajo"/&gt;
      &lt;/property&gt;
      &lt;property name="periodo"&gt;
          &lt;column name="periodo"/&gt;
      &lt;/property&gt;
  &lt;/class&gt;
  </code></pre>
  
  <p></p>