| 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 follow SQL databases have been certified: 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. |
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 frevvo.xml is located in <frevvo-home>/frevvo/tomcat/conf/Catalina/localhost directory. |
|
...
If you are trying a different database type and do not see an example in frevvo.xml for your database, you can create a new data source entry. Hibernate supports the following dialects however has only been certified to run with a subset of these databases. For additional dialects see Hibernate documentation. Database Setup
...
for all the databases officially supported by frevvo. |
- org.hibernate.dialect.HSQLDialect
- org.hibernate.dialect.MySQL5Dialect
- org.hibernate.dialect.MySQL5InnoDBDialect
- org.hibernate.dialect.Oracle9Dialect
- org.hibernate.dialect.OracleDialect
- org.hibernate.dialect.PostgreSQLDialect
- org.hibernate.dialect.SQLServerDialect
- org.hibernate.dialect.Sybase11Dialect
...