1
|
1/Create database for SITOOLS2
|
2
|
|
3
|
from the root directory execute:
|
4
|
java -jar workspace/libraries/org.hsqldb/sqltool.jar --autoCommit --inlineRc=url=jdbc:hsqldb:file:data/HSQLDB/sitools,user=sitools,password= < database/HSQLDB/SITOOLS_CREATE_SCHEMA.sql
|
5
|
java -jar workspace/libraries/org.hsqldb/sqltool.jar --autoCommit --inlineRc=url=jdbc:hsqldb:file:data/HSQLDB/sitools,user=sitools,password= < database/HSQLDB/SITOOLS_CREATE_TABLES.sql
|
6
|
java -jar workspace/libraries/org.hsqldb/sqltool.jar --autoCommit --inlineRc=url=jdbc:hsqldb:file:data/HSQLDB/sitools,user=sitools,password= < database/HSQLDB/SITOOLS_INSERT_DATA.sql
|
7
|
|
8
|
Database will be created in folder data/HSQLDB/sitools
|
9
|
|
10
|
Edit the sitools.properties file with the following properties :
|
11
|
Starter.DATABASE_DRIVER=org.hsqldb.jdbcDriver
|
12
|
Starter.DATABASE_URL=jdbc\:hsqldb:file:../../data/HSQLDB/sitools
|
13
|
Starter.DATABASE_USER=sitools
|
14
|
Starter.DATABASE_PASSWORD=sitools
|
15
|
Starter.DATABASE_SCHEMA=sitools
|
16
|
|
17
|
|
18
|
2/Create database for the SITOOLS2 tests
|
19
|
from the root directory execute:
|
20
|
java -jar workspace/libraries/org.hsqldb/sqltool.jar --autoCommit --inlineRc=url=jdbc:hsqldb:file:data/TESTS/HSQLDB/sitools,user=sitools,password= < database/HSQLDB/sitools-tests.sql
|
21
|
|
22
|
Database will be created in folder data/TESTS/HSQLDB/sitools
|