4.1.4.1. Embeded mode

Orbada program uses by default HSQLDB database in Embedded mode. The database stores the definitions of the drivers, connection schemas, and other settings. Embedded mode applications can not run several times at the same time. However, nothing prevents to configure the program to connect to a HSQLDB database server, or even Oracle.

In directory %USER_HOME%/.orbada/config you find file orbada.properties. In this file located a configuration database connection HSQLDB in Embedded mode. Content below:

#EMBEDED HSQLDB
internal.db.driver=HSQLDB
internal.db.class=org.hsqldb.jdbcDriver
internal.db.url=jdbc:hsqldb:file:$(orbada.home)/data/hsqldb/orbada
internal.db.user=sa
internal.db.password=
internal.db.source=$(user.dir)/jdbc/hsqldb-internal/hsqldb.jar
data.type.blob=BINARY
data.type.clob=VARCHAR

4.1.4.2. HSQLDB Server

To configure the program so as to connect to the HSQLDB database in server mode, you must in file orbada.properties comment out these lines with a # char and uncomment the following.

#SERVER HSQLDB
internal.db.driver=HSQLDB
internal.db.class=org.hsqldb.jdbcDriver
internal.db.url=jdbc:hsqldb:hsql://localhost/orbada
internal.db.user=sa
internal.db.password=
internal.db.source=$(user.dir)/jdbc/hsqldb-internal/hsqldb.jar
data.type.blob=BINARY
data.type.clob=VARCHAR

The Orbada program uses HSQLDB version 1.8, which is located in jdbc/hsqldb-internal and must remain in this version..

To start the HSQLDB server can use the following command (Windows):
@java -classpath "./jdbc/hsqldb-internal/hsqldb.jar" org.hsqldb.Server -database.0 "file:%USERPROFILE%/.orbada/data/hsqldb/orbada" -dbname.0 orbada

4.1.4.3. Oracle Server

To configure the program so as to connect to the Oracle database in server mode, you must in file orbada.properties comment out these lines with a # char and uncomment the following.

In the case of Oracle database is required that prior to starting the program the first time, create a user for example ORBADA.

#SERVER Oracle
internal.db.driver=Oracle
internal.db.class=oracle.jdbc.OracleDriver
internal.db.url=jdbc:oracle:thin:@localhost:1521:orcl
internal.db.user=orbada
internal.db.password=orbada
internal.db.source=./jdbc/ojdbc6.jar
internal.db.extra.library=./jdbc/orai18n.jar
data.type.blob=BLOB
data.type.clob=CLOB

After starting the first time of Orbada program, all database objects are created automatically.

4.1.4.4. PostgreSQL server

To configure the program so as to connect to the PostgreSQL database in server mode, you must in file orbada.properties comment out these lines with a # char and uncomment the following.

In the case of PostgreSQL database is recomended that prior to starting the program the first time, create a schema and user for example ORBADA.

#SERVER POSTGRESQL
internal.db.driver=PostgreSQL
internal.db.class=org.postgresql.Driver
internal.db.url=jdbc:postgresql://localhost:5432/postgres
internal.db.user=orbada
internal.db.password=orbada
internal.db.source=./jdbc/postgresql-9.2-1002.jdbc4.jar
data.type.blob=bytea
data.type.clob=varchar
usedb.auto-command-quoted-name=false

After starting the first time of Orbada program, all database objects are created automatically.