title: I can`t see my created tables in HSQLDB, what could be the issue?
body: <p>My environment is HSQLDB, Maven and spring-boot.
  I have created 2 entity POJOs. I do see the <code>CREATE TABLE</code> command under <code>testedb.log</code> file. But when I open <code>Data Source Explorer</code> in Eclipse, I can`t see my tables, albeit I do see all the system tables.</p>
  
  <p>I have looked at this question too, but no vail: <a href="https://stackoverflow.com/questions/35240017/where-can-i-see-the-hsql-database-and-tables">Where can I see the HSQL database and tables</a></p>
  
  <p>Here is my <strong>partial</strong> pom.xml:</p>
  
  <pre><code>&lt;dependency&gt;
          &lt;groupId&gt;org.hsqldb&lt;/groupId&gt;
          &lt;artifactId&gt;hsqldb&lt;/artifactId&gt;
          &lt;version&gt;2.4.0&lt;/version&gt;
          &lt;scope&gt;runtime&lt;/scope&gt;
  &lt;/dependency&gt;
  </code></pre>
  
  <p>Here is my <strong>partial</strong> <code>application.properties</code>:</p>
  
  <pre><code># DataSource
  #spring.datasource.driverClassName=org.hsqldb.jdbc.JDBCDriver
  spring.datasource.url=jdbc:hsqldb:file:resources/db/testedb;DATABASE_TO_UPPER=false
  #spring.datasource.url=jdbc:hsqldb:mem:memTestdb
  spring.datasource.username=sa
  spring.datasource.password=
  
  # Hibernate
  spring.jpa.show-sql=true
  #spring.jpa.hibernate.ddl-auto=create-drop
  spring.jpa.hibernate.ddl-auto=create
  </code></pre>
  
  <p>And below is my HSQLDB created on disk:</p>
  
  <p><a href="https://i.stack.imgur.com/UDFoq.png" rel="noreferrer">HSQLDB folder in my workspace</a>
  Here is my  <strong>partial</strong> <code>testedb.script</code>:</p>
  
  <pre><code>SET FILES LOG SIZE 50
  CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e'
  ALTER USER SA SET LOCAL TRUE
  CREATE SCHEMA PUBLIC AUTHORIZATION DBA
  SET SCHEMA PUBLIC
  CREATE SEQUENCE PUBLIC.HIBERNATE_SEQUENCE AS INTEGER START WITH 1
  CREATE MEMORY TABLE PUBLIC.ENQUIRY_HISTORY(ID BIGINT NOT NULL PRIMARY  KEY,FROM_AMOUNT DOUBLE NOT NULL,FROM_CURRENCY VARCHAR(255) NOT NULL,QUERY_DATE TIMESTAMP NOT NULL,TO_AMOUNT DOUBLE NOT NULL,TO_CURRENCY VARCHAR(255) NOT NULL,USER_ID BIGINT NOT NULL,VERSION INTEGER NOT NULL)
  CREATE MEMORY TABLE PUBLIC.USERS(ID BIGINT NOT NULL PRIMARY KEY,EMAIL VARCHAR(255) NOT NULL,LAST_LOGIN TIMESTAMP NOT NULL,PASSWORD VARCHAR(255) NOT NULL,VERSION VARCHAR(255) NOT NULL)
  ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1
  ALTER SEQUENCE PUBLIC.HIBERNATE_SEQUENCE RESTART WITH 1
  SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC
  GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC
  </code></pre>
  
  <p>Please see above that the <code>CREATE TABLE</code> contains the word <strong>MEMORY</strong> even though I have created <strong>file</strong> DB.</p>
  
  <p>And by <code>testsdb.log</code>:</p>
  
  <pre><code>/*C12*/SET SCHEMA PUBLIC
  drop table enquiry_history if exists
  drop table users if exists
  drop sequence hibernate_sequence if exists
  create sequence hibernate_sequence start with 1 increment by 1
  create table enquiry_history (id bigint not null, from_amount float not null, from_currency varchar(255) not null, query_date timestamp not null, to_amount float not null, to_currency varchar(255) not null, user_id bigint not null, version integer not null, primary key (id))
  create table users (id bigint not null, email varchar(255) not null, last_login timestamp not null, password varchar(255) not null, version varchar(255) not null, primary key (id))
  /*C14*/SET SCHEMA PUBLIC
  DISCONNECT
  /*C17*/SET SCHEMA PUBLIC
  </code></pre>
  
  <p>And Finally here is my screen shot of Database 
  <a href="https://i.stack.imgur.com/hkjtG.png" rel="noreferrer">Data Source Explorer</a></p>
  
  <p>Any pointer will be awesome, thanks for your time.</p>