| 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. |
|
...
- 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.
...
It is also appropriate to copy the driver into any location that is in the CLASSPATH of your servlet container. In a tomcat installation another . Another location would be <CATALINA_HOME>/lib.
...