Confluence Docs 3.0 : Connecting to HSQLDB using DBVisualizer This page last changed on Jun 10, 2008 by smaddox. The purpose of this guide is to walk you through connecting to Confluence's embedded Hypersonic SQL Database using the Database Administration tool DBVisualizer. Below are step by step instructions on how to Configure DBVisualizer and connect it to HSQLDB. #### Prerequisites Download and install the latest copy of DBVisualizer. You will also need to download a copy (preferably the latest version) of HSQLDB Extract the contents of the HSQLDB archive Ensure that Confluence is not running. ### Connection Procedure Please ensure that you read and follow the instructions below carefully.
| Remember to backup your `<confluence-home>/database` folder before attempting any modifications
#### 1. Enter Connection Name Click on the icon highlighted in Red Enter an identifiable name for the connection. e.g. conf2.5.4-std #### 2. Select JDBC Driver From the drop down list select HSQLDB Embedded Click on Load Driver Files Browse to directory where the `HSQLDB.jar` file is located #### 3. Select Database Path Browse to your `<Confluence-Home>` directory Open the Database folder Select the `confluencedb.properties` file #### 4. Enter Connection Details Remove the ".properties" from the end of `confluencedb` Type in sa for the username Leave the password field blank refer to the example screenshot above if you are unsure #### 5. Connect to embedded Database Click on Test Connection to verify that the details are correct. Click on "Finish" to complete the setup Select the connection from the list on the left hand side. 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 confluence.cfg.xml as the URL and you're good to go. ### Related Topics Universal SQL client Squirrel HSQL Enable Hibernate Logging Database Tables Reference Confluence data model Attachments: 3.jpg (image/jpeg) 2.jpg (image/jpeg) 1.jpg (image/jpeg) 4.jpg (image/jpeg) 4.jpg (image/jpeg)

Document generated by Confluence on Nov 05, 2009 23:34