• Introduction
• News
• Project Status
• Roadmap
• Sourceforge Project Home
• History

  ---

• Features
• Screenshots
• Download
• Server Installation
• Ultra Quick Server Installation
• Client Installation
• FAQ

  ---

• Architecture
• Development
• Integration Tests Results
• GUI Tests Results
• Tests Coverage
• Coding Style Checks

  ---

• HiveBoard Team
• Acknowledgements
• License

2. Setup the HiveBoard database on Derby

At this step, we suppose that your Derby database server is up and running, and that you have the following Derby directory in your PATH: frameworks/NetworkServer/bin, with script files correctly configured for your setup.

You will first create the new HiveBoard database on your Derby server by using Derby "ij" tool:

cd hb-server-bin/initdb/derby
ij
ij> connect 'jdbc:derby://localhost/hiveboard;create=true' user 'hiveboard' password 'hiveboard';
ij> run 'schema.sql';
ij> run 'initdata-prod.sql';
ij> exit;

The file schema.sql creates the structure of the hiveboard database (tables, indexes). The file initdata-prod.sql creates one specific account (login='admin', empty password) who has HiveBoard administrator rights and can thus create other accounts (through the HiveBoard client application).

Before proceeding with the next step, let's check that the HiveBoard database has been correctly initialized:

ij
ij> connect 'jdbc:derby://localhost/hiveboard' user 'hiveboard' password 'hiveboard';
ij> select * from ACCOUNT;
ij> exit;

ij should display 'admin' in the list of accounts.