Connecting to HSQLDB Using DBVisualizer

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

The purpose of this guide is to walk you through connecting to Crowd'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.

前提条件

  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 Crowd is not running

Connection Procedure

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

Remember to backup your <Crowd-home>/database folder before attempting any modifications

1. Enter Connection Name

  1. Click on the icon highlighted in Red
  2. Enter an identifiable name for the connection. e.g. conf2.5.4-std

2. Select JDBC Driver

  1. From the drop down list select HSQLDB Embedded
  2. Click on Load Driver Files
  3. Browse to directory where the HSQLDB.jar file is located. This file is bundled in Crowd and can be found at <Crowd-installation>/Crowd/WEB-INF/lib/hsqldb-*.jar.

3. Select Database Path

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

4. Enter Connection Details

  1. Remove the ".properties" from the end of Crowddb
  2. Type in sa for the username
  3. Leave the password field blank

Refer to the example screenshot above if you are unsure

5. Connect to embedded Database

  1. Click on Test Connection to verify that the details are correct.
  2. Click on "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 crowd.cfg.xml as the URL and you're good to go.

関連トピック

Universal SQL client Squirrel
HSQL
Enable Hibernate Logging
Database Tables Reference
Crowd data model

最終更新日: 2015 年 2 月 25 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.