1 |
d2a8c3fd
|
Marc NICOLAS
|
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 |