Connecting to (embedded) HSQL Database using Dbvisualiser

The purpose of this guide is to walk you through connecting to Bamboo's embedded Hypersonic SQL Database using the Database Administration tool DBVisualizer.

The step by step instructions on how to Configure DBVisualizer and connect it to HSQLDB are below:

Prerequisites

1. Download and install the latest copy of DBVisualizer.
2. You will also need to download a copy (preferably the latest version) of HSQLDB.
3. Extract the contents of the HSQLDB archive.
4. Ensure that Bamboo is not running.

Connection Procedure

Please ensure that you read and follow the instructions below carefully.

1. Enter Connection Name

1. Click on the icon highlighted in red.
2. Enter an identifiable name for the connection, e.g. Bamboo_db.
   

2. Select JDBC Driver

1. Select HSQLDB Embedded, from the drop down list.
2. Click on Load Driver Files.
3. Browse to directory where the HSQLDB.jar file is located.
   

3. Select Database Path

1. Browse to your <Bamboo-Home> directory.
2. Open the Database folder.
3. Select the defaultdb.properties file.
   

4. Enter Connection Details

1. Remove the ".properties" (e.g. <Bamboo-Home>/database/defaultdb ) from the end of defaultdb.
2. Type in sa for the username.
3. Leave the password field blank.

(Refer to the example screenshot above).

5. Connect to the Embedded Database

1. Click 'Test Connection' to verify that the details are correct.
2. Click 'Finish' to complete the setup.
3. Select the connection from the list on the left hand side.
4. You can now click on "Connect" to connect to the embedded database.
   
   

HSQL Database Manager

Alternatively, you can use HSQLDB's database manager. Just copy the value of hibernate.connection.url in bamboo.cfg.xml as the URL and you're good to go.