Hi!

I'm using a hsqldb for JUnit tests, however some of the tables are not created and sometimes I get a:
java.sql.SQLException: Table not found in statement [select this_.id as ...
exception.

My configuration file looks like this:

<property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property name="connection.url">jdbc:hsqldb:hsql:bled</property>
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>

<property name="connection.username">sa</property>
<property name="connection.password"></property>

<property name="connection.pool_size">0</property>
<property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

<property name="show_sql">true</property>
<property name="format_sql">true</property>

<property name="hbm2ddl.auto">create-drop</property>
<property name="current_session_context_class">thread</property>

<property name="jdbc.batch_size">0</property>
<property name="connection.autocommit">true</property>

<!-- mapping classes -->

I did some searching on google, however, I couldn't find an acceptable solution.

Cheers! and thank you in advance!