ART
a lightweight reporting solution

Home
OverView
ScreenShots
ChangeLog
Download
Quick Start
Install
Admin
Developers
Credits
Help

Site Map


This is an Open Source software, see license for more info.

Hosted by:
SourceForge Logo

ART - Use HSQLDB as ART Repository


  1. Unzip the hsqldb-art.zip file you find in the art-X.Y.zip archive
  2. Edit the .script file in order to change the password in the line:
  3.       CREATE USER ART PASSWORD "xxx" ADMIN
    
  4. Obtain the hsqldb.jar jdbc driver-database - you can download the latest driver from http://hsqldb.sourceforge.net. Copy the driver in the art.war WEB-INF/lib directory or in Tomcat common/lib directory (refer to your Application server documentation if you are not using Tomcat).
  5. Deploy the art.war archive, log in and in the ART Properties page, specify the following:
  6. JDBC url:
    jdbc:hsqldb:$HSQL_HOME/art_repository_hsqldb
    JDBC driver:
    org.hsqldb.jdbcDriver
    Username/Password: use the ones you specified at point 2.
    
$HSQL_HOME is the path where you unzipped the file; use jdbc:hsqldb:C:\tomcat\path_to\art_repository_hsqldb format in MS Win platform

Note: for optimal performance/production environment switch to the hsqldb "in process" mode, see the hsqldb manual for more info.