Database

The Plazma supports the following databases:

• Oracle
• PostgreSQL
• MySQL
• Firebird
• HSQL

Create a database

A installation of the Plazma includes physical database files only to HSQL.
The files available in a folder <Plazma>/db/hsql.

If you want to use a database of other vendors, you have to create database and run SQL scripts.
To create a database, you can use various tools.

For example:

• Oracle - SQL* Plus
• PostgreSQL - pgAdmin
• MySQL Query Browser
• Firebird - ISQL
• HSQL - Database Manager (<HSQL>/demo/runManager.bat)

SQL scripts available in <Plazma>/db/script.
You can run the following script to create structure and fill a new database:

<Plazma>/db/script/createdb/<database-vendor>/<language>/create_plazma_db.sql - live database
<Plazma>/db/script/createdb/<database-vendor>/<language>/create_plazma_db_demo.sql - demo database


<database-vendor> - vendor of the database (oracle, postgresql, mysql, firebird, hsql)
<language> - language (en, de, ru, uk)

For the Firebird database and the English language:

<Plazma>/db/script/createdb/firebird/en/create_plazma_db.sql - live database
<Plazma>/db/script/createdb/firebird/en/create_plazma_db_demo.sql - demo database


More: Oracle PostgreSQL MySQL Firebird HSQL

JDBC drivers

A installation of the Plazma includes all JDBC drivers for the supported databases.
JAR files available in a folder <Plazma>/lib/<database-vendor>.
If you use other databases you have to download JDBC drivers from the vendor web site and add driver files to CLASSPATH.

More: Oracle PostgreSQL MySQL Firebird HSQL

Connect to a database

For connected need to change the relevant properties in the file <Plazma>/conf/jdbc.properties.

For example:

# Set properties to connect to the Firebird database
jdbc.driverClassName=org.firebirdsql.jdbc.FBDriver
jdbc.url=jdbc:firebirdsql:localhost/3050:C:\\DATA\\plazma.fdb
jdbc.username=sysdba
jdbc.password=masterkey


More: Oracle PostgreSQL MySQL Firebird HSQL

Summary