title: How to start HSQLDB in server mode from Spring boot application
body: <p>I have a Spring boot application, running with jpa data and hsqldb 2.3.3 (in Centos 7), the application runs fine but I would like to use HSQLDB database manager to check the data status, however it failed:</p>
  
  <p>application.properties:</p>
  
  <pre><code>spring.datasource.url=jdbc:hsqldb:mem:testdb
  spring.datasource.username=sa
  spring.datasource.password=
  
  spring.jpa.database-platform=org.hibernate.dialect.HSQLDialect
  spring.jpa.show-sql=true
  spring.jpa.hibernate.ddl-auto=create
  </code></pre>
  
  <p>Command to start HSQLDB:</p>
  
  <pre><code>java -cp /home/mycentos/.m2/repository/org/hsqldb/hsqldb/2.3.3/hsqldb-2.3.3.jar org.hsqldb.util.DatabaseManagerSwing
  </code></pre>
  
  <p>If I tried to log in with HSQLDB server mode, it pops <code>Connection refused</code> error</p>
  
  <pre><code>jdbc:hsqldb:hsql://localhost/testdb
  </code></pre>
  
  <p>If I tried to log in in-memory db, I can log in but no table and data showing up</p>
  
  <pre><code>jdbc:hsqldb:hsql:testdb
  </code></pre>
  
  <p>Question:</p>
  
  <ol>
  <li>How to make it works?</li>
  <li>Do I have to refer to the hsqldb.jar from tomcat deployment folder because that is the one using by the application?</li>
  <li>Any configuration difference to configure hsqldb in server mode or in-memory mode from Spring application?</li>
  <li>Can any method make in-memory mode working in such situation (to check data by db created Spring boot)?</li>
  </ol>