Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column

These steps are required when you convert from a demo/trial

Frevvoproduct
server installation to a production/test installation.

Tip

While you are demo-ing

Frevvoproduct
you do not need to do the Database Setup steps discussed below.

Your

Frevvoproduct
 server requires an SQL database for storing users and form submissions.

Info

frevvo only supports/certifies the 

Frevvoproduct
running in the Apache Tomcat container. Refer to our Supported Platforms for the list of Application Servers and databases supported/certified by frevvo.

Tip
  • If you are using Oracle12c as your database, the jdbc driver must be version 7 ojdbc.jar for the Insight Data batch process to function properly. Refer to the Install a JDBC Driver topic for the details.
  • It is recommended practice to use a named user (schema) account with the proper privileges when connecting
    Frevvoproduct
    to Oracle databases

    .

    The built in SYSTEM user account will not work.


    The default HSQLDB is ONLY sufficient for demo/trial versions of

    Frevvoproduct
    . All production
    Frevvoproduct
    users MUST switch their
    Frevvoproduct
    software to a production quality database.

    Warning
    • 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.

    Column
    width240px

    On This page:

    Table of Contents
    maxLevel1

    ...

    1. Locate the sharedfrevvoDS data source url parameter and decide on a name for the frevvo database. For the SQL Server it would look like this: "url="jdbc:sqlserver://localhost:1433;databaseName=frevvo". You can change the name "frevvo" to whatever you wish, "
      Frevvoproduct
      " for example. But it must match the database name you create in your SQL server. See configure the connection Url below.
    2. Create a UTF-8 encoded database "frevvo" (assuming you left the url parameter database name as the default) in your SQL server
    3. Set the sharedfrevvoDS data source url parameter to your database server. See configure the connection Url below.
    4. Set the sharedfrevvoDS data source username and password parameters to a user that has read and write permissions to the frevvo database.

      Tip

      It is recommended practice to use a named user (schema) account with the proper privileges when connecting

      Frevvoproduct
      to Oracle databases. The built in SYSTEM user account will not work.

    5. The frevvo database setup is now complete. 
      Frevvoproduct
       will create all the necessary tables upon startup.

    ...

    Info

    If you are using SQL Server, it is recommended that you append the sendStringParametersAsUnicode property with a value of false to your database connection URL. This property will improve performance. You can find more information about this property on this Microsoft website.

    If you do not see the property, when configuring the Connection URL to your database, add it.

    Code Block
    url="jdbc:sqlserver://localhost:1433;databaseName=frevvo;sendStringParametersAsUnicode=false"/> 

    ...