| Section |
|---|
| Column |
|---|
These steps are required when you convert from a demo/trial server installation to a production installation. | Tip |
|---|
While you are demo-ing you do not need to do the Database Setup steps discussed below. |
Your server requires an SQL database for storing users and form submissions. The following SQL databases have been certified: - MySQL5.7
- Microsoft SQL Server 2012, 2014
Oracle 12c
The server may function with other SQL database types but only the above set has been certified. | Warning |
|---|
- The default HSQLDB is ONLY sufficient for demo/trial versions of . All production users MUST switch their software to a production quality database.
- You cannot migrate the data (user, roles, applications) automatically from HSQL to your production database. See this topic for the manual procedure details.
|
The following steps describe how to change the underlying database from the demo/trial HSQLDB to a production quality SQL database. The database configuration file, server.xml is located in <frevvo-home>/frevvo/tomcat/conf directory. |
|
...
You do not have to do this if you are using MySQL or Oracle databases because the READ SUBMITTED SNAPSHOT option is turned on by default.
There are two ways to turn on the option:
...
- SQL Server JDBC Driver
- MySQL - 5.1.11 or later is recommended to resolve Tomcat memory leak issues. Versions 5.1.31 - 5.1.36 of the MySQL JDBC driver are recommended if you are using MySQL 5.6+
Oracle
Once you have the driver you need, copy it to <frevvo-home>/tomcat/lib.
...