HSQLDB start many databases
To start many database we can create simple file "*start.sh*"

Before start to use create separate folders for each databases.

*/opt/db/trunk*

*/opt/db/master*

Next one copy to "*start.sh*":

    #!/bin/sh
    java -cp ./hsqldb/lib/hsqldb.jar  org.hsqldb.server.Server --database.0 file:/opt/db/master/master --dbname.0 master --database.1 file:/opt/db/trunk/trunk --dbname.1 trunk

Make this file to be executable:

    chmod +x start.sh

Start to run:

    $ ./hsqdb.sh

Output:

    ...
    [Server@15c7850]: Database [index=0, id=0, db=file:/opt/db/trunk/trunk, alias=trunk] opened sucessfully in 426 ms.
    [Server@15c7850]: Database [index=1, id=1, db=file:/opt/db/master/master, alias=master] opened sucessfully in 128 ms.
    ...
    [Server@15c7850]: From command line, use [Ctrl]+[C] to abort abruptly

    

So you will get two databases with aliases: **trunk** and **master**

Example how to configure HSQL Database Manager:

> Type:    HSQL Database engine server

> Driver:  org.hsqldb.jdbcDriver

> URL:     jdbc:hsqldb:hsql://localhost/**trunk**

> User:    SA

> Password: 

You can change the alias trunk to another alias

JDBC URL connection:
    
> jdbc:hsqldb:hsql://localhost:9001/**trunk**

> jdbc:hsqldb:hsql://localhost:9001/**master**
HSQLDB start many databases
===

To start many database we can create simple file "*start.sh*"

Before start to use create separate folders for each databases.

*/opt/db/trunk*

*/opt/db/master*

Next one copy to "*start.sh*":

    #!/bin/sh
    java -cp ./hsqldb/lib/hsqldb.jar  org.hsqldb.server.Server --database.0 file:/opt/db/master/master --dbname.0 master --database.1 file:/opt/db/trunk/trunk --dbname.1 trunk

Make this file to be executable:

    chmod +x start.sh

Start to run:

    $ ./hsqdb.sh

Output:

    ...
    [Server@15c7850]: Database [index=0, id=0, db=file:/opt/db/trunk/trunk, alias=trunk] opened sucessfully in 426 ms.
    [Server@15c7850]: Database [index=1, id=1, db=file:/opt/db/master/master, alias=master] opened sucessfully in 128 ms.
    ...
    [Server@15c7850]: From command line, use [Ctrl]+[C] to abort abruptly

    

So you will get two databases with aliases: **trunk** and **master**

Example how to configure HSQL Database Manager:

> Type:    HSQL Database engine server

> Driver:  org.hsqldb.jdbcDriver

> URL:     jdbc:hsqldb:hsql://localhost/**trunk**

> User:    SA

> Password: 

You can change the alias trunk to another alias

JDBC URL connection:
    
> jdbc:hsqldb:hsql://localhost:9001/**trunk**

> jdbc:hsqldb:hsql://localhost:9001/**master**