Versions Compared

Old Version 4

changes.mady.by.user Former user

Saved on

compared with

New Version 5

changes.mady.by.user Former user

Saved on

Key

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

If you were using version 2.4 of the Database Connector in your previous installation, you can use the configuration files from that installation with version 2.5+ of the connector. This will work if you are running the connector in the tomcat bundle or standalone.

Column
width400px

 On This Page:

Table of Contents

...

The Database Connector need to know where and how to connect to your database. Datasources are defined using resouceresource-def/resource-ref elements for each queryset in your configuration.xml file

The Live Forms database connector needs to know:

  • the path to your database
  • a username to login to your database
  • a password for this username
  • which JDBC driver your database requires.

Using <resource-def> in the v2.4 configuration.xml file

...

  1.  Edit frevvo\tomcat\conf\Catalina\localhost\context.xml.default file in your v7.2 installation to add the "frevvo.connectors.database.configuration' and Resource Name parameters if they are not already defined.  A sample context.xml.default file for MySQL is shown below

    Code Block
    <Context swallowOutput="true" unloadDelay="40000" useHttpOnly="true">
        <Manager className="org.apache.catalina.session.PersistentManager" saveOnRestart="false">
                <Store className="org.apache.catalina.session.FileStore"/>
        </Manager>
        <Parameter name="insight.server.url" value="http://localhost:8983/solr" override="false"/>
        <Parameter name="frevvo.connectors.database.configuration" value= "<path to the configuration.xml file>" override="false"/>
        <Resource name="jdbc/<your database name>"
          auth="Container"         
          driverClassName="com.mysql.jdbc.Driver"
          username="<your database user>"
          password="<your database password>"
          type="javax.sql.DataSource"
          url="jdbc:mysql://localhost/<your queryset name>?autoconnect=true"/>
</Context>
  2. Verify that the resource-ref is defined in your configuration.xml file for each queryset.
  3. Alternatively, you can copy frevvo\tomcat\conf\Catalina\localhost\context.xml.default and dbconfig\configuration.xml to appropriate location in the v7.2+ tomcat bundle.

Configure the v2.5 connector using the 2.4 configuration files in Standalone mode

...