title: in-process mode hsqldb doesn't create tables and doesn't save values
body: <p>My main class:</p>
  <pre><code>public static void main(String[] args) {
      Connection con = null;
      Statement stmt = null;
      int result = 0;
      try {
          Class.forName(&quot;org.hsqldb.jdbc.JDBCDriver&quot;);
          con = DriverManager.getConnection(&quot;jdbc:hsqldb:file:data&quot;, &quot;SA&quot;, &quot;SA&quot;);
          stmt = con.createStatement();
          result = stmt.executeUpdate(&quot;CREATE TABLE surr (ID INTEGER IDENTITY NOT NULL, NAME VARCHAR(40) NOT NULL ) &quot;);
          con.commit();
      } catch (Exception e) {
          e.printStackTrace(System.out);
      }
      System.out.println(result + &quot; rows effected&quot;);
      System.out.println(&quot;Rows inserted successfully&quot;);
  }
  </code></pre>
  <p>Pom xml:</p>
  <pre><code>&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;
  &lt;project xmlns=&quot;http://maven.apache.org/POM/4.0.0&quot;
           xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema-instance&quot;
           xsi:schemaLocation=&quot;http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd&quot;&gt;
      &lt;modelVersion&gt;4.0.0&lt;/modelVersion&gt;
  
  
      &lt;groupId&gt;org.example&lt;/groupId&gt;
      &lt;artifactId&gt;untitled&lt;/artifactId&gt;
      &lt;version&gt;1.0-SNAPSHOT&lt;/version&gt;
  
      &lt;dependencies&gt;
          &lt;dependency&gt;
              &lt;groupId&gt;org.hsqldb&lt;/groupId&gt;
              &lt;artifactId&gt;hsqldb&lt;/artifactId&gt;
              &lt;version&gt;2.5.0&lt;/version&gt;
          &lt;/dependency&gt;
      &lt;/dependencies&gt;
  
      &lt;build&gt;
          &lt;plugins&gt;
              &lt;plugin&gt;
                  &lt;groupId&gt;org.apache.maven.plugins&lt;/groupId&gt;
                  &lt;artifactId&gt;maven-compiler-plugin&lt;/artifactId&gt;
                  &lt;configuration&gt;
                      &lt;source&gt;1.8&lt;/source&gt;
                      &lt;target&gt;1.8&lt;/target&gt;
                  &lt;/configuration&gt;
              &lt;/plugin&gt;
          &lt;/plugins&gt;
      &lt;/build&gt;
  
  &lt;/project&gt;
  </code></pre>
  <p>The automatically generated data.script file absolutely refuses to create tables. Once it was possible to create a table, and even managed to insert a single row, but no more. I found out that if you insert rows into a miraculously created table, the rows are created, they can be obtained in the current connection, but when the main method completes, the changes are not saved in data. script. What can be done about it?</p>