hsqldb basics

Start in-memory HSQLDB server

An example of creating an in-memory HSQLDB server

hibernate.cfg.xml

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

  <session-factory>

    <property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
    <!-- set url to target/hsql:mem:test so that files are written to build dir -->
    <property name="connection.url">jdbc:hsqldb:target/hsql:mem:test</property>
    <property name="connection.username">sa</property>
    <property name="connection.password"></property>

    <property name="connection.pool_size">1</property>

    <property name="dialect">org.hibernate.dialect.HSQLDialect</property>

    <property name="current_session_context_class">thread</property>

  </session-factory>

</hibernate-configuration>

ServerApplication.java

import org.hsqldb.server.Server;

public class ServerApplication {

  public static void main(String[] args) throws Exception {
    Server server = new Server();

    server.setDatabaseName(0, "test");
    // set location to target/mem:test so that files are written to build dir
    server.setDatabasePath(0, "target/mem:test");
    server.setSilent(false);
    server.setTrace(true);
    server.start();
    // do stuff
    server.shutdown();
  }
}