Compound Registration can be configured to use the following database engines:
To prepare your database for installation you need to execute the following steps:
Create a database user (e.g. regsys_user) that Compound Registration will use to connect to the database server.
Usually, when you create a user in Oracle, Oracle will create a 'schema' automatically.
Create an empty database (e.g. regsys), that uses UTF-8 character set (or AL32UTF8, the Oracle equivalent of UTF-8)
Ensure that the user has permission to connect to the database, and permission to create and populate tables.
MySQL 5.5 - 5.7.5 example:
For MySQL 5.7.6 and above, you must also include the REFERENCES permission:
A JDBC driver is a software component enabling a Java application to interact with a database. To connect with individual databases, JDBC requires drivers for each database. These libraries cannot be packed with the Compound Registrations system, you have to copy this library to the application server.
For MySQL users:
Download the recommended MySQL driver from http://dev.mysql.com/downloads/connector/j
You can download either the
.tar.gz or the
.zip file by selecting the 'Platform Independent' option. Extract the jar for the driver (e.g.
mysql-connector-java-5.x.x-bin.jar) from the archive.
For Oracle users:
Depending on your Oracle version, download the jar file from this website: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
Once you've got the proper .jar JDBC driver (e.g. mysql-connector-java-5.1.24.jar or ojdbc6-220.127.116.11.jar), copy to your
After you copied the JDBC driver, restart your Tomcat, so the changes will take effect.