title: No schema in file database after running program persisted to hsqldb:file via hibernate
body: <p>Here is hibernate.cfg.xml:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"&gt;
  &lt;hibernate-configuration&gt;
    &lt;session-factory&gt;
      &lt;property name="hibernate.connection.url"&gt;jdbc:hsqldb:file:test_db_file&lt;/property&gt;
      &lt;property name="hsqldb.write_delay"&gt;false&lt;/property&gt;
      &lt;property name="hibernate.connection.driver_class"&gt;org.hsqldb.jdbcDriver&lt;/property&gt;
      &lt;property name="dialect"&gt;org.hibernate.dialect.HSQLDialect&lt;/property&gt;
      &lt;property name="hibernate.connection.username"&gt;combine1&lt;/property&gt;
      &lt;property name="hibernate.connection.password"&gt;&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;!-- Echo all executed SQL to stdout --&gt;
      &lt;property name="show_sql"&gt;true&lt;/property&gt;
      &lt;!-- Drop and re-create the database schema on startup --&gt;
      &lt;property name="hbm2ddl.auto"&gt;create&lt;/property&gt;
      &lt;!--
           few resources
      --&gt;
  
    &lt;/session-factory&gt;
  &lt;/hibernate-configuration&gt;
  </code></pre>
  
  <p>When I change hsqldb to mysql db, it works fine. But when I leave it like this, and I connect hsqldb:file as database in NetBeans, there is nothing in Public schema where I suppose to find created tables after running program.</p>
  
  <p>During runtime, classes are persisted, I can load them from session etc., but after program ends, there is nothing. Except in test_db_file.script are queries to create desired schema, but not rows I saved into db. </p>
  
  <p>Here is my simple main, as I wrote, when I use some mysql database, it works:</p>
  
  <pre><code>import java.util.List;
  import org.hibernate.Criteria;
  import org.hibernate.Session;
  import resources.HibernateUtil;
  import website.Website;
  
  public class MrhAdministration {
  
    public static void main(String[] args) {
      Session session = HibernateUtil.getSessionFactory().getCurrentSession();
      session.beginTransaction();
  
      WebsiteCreator.create(session);
  
      Criteria criterial = session.createCriteria(Website.class);
      for (Website w : (List&lt;Website&gt;) criterial.list()) {
        System.out.println("Sites: " + w.getSiteName() + " " + w.getSiteUrl());
      }
      session.getTransaction().commit();
    }
  }
  </code></pre>
  
  <p>Thanks for answers!</p>