Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version 3

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
width240px

 On This Page:

Table of Contents

...

  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

  1. Stop the Db Connector if it is running. You can do this by closing the window if you started the DB Connector with the java command, running the Stop-DB Connector.sh file for *nix OS or the Stop-Db Connector-Service.bat file for Windows OS.
  2. Copy the 2.4 configuration.xml file to the <db-home>\database\database-connector-2.5.0\config folder.

  3. Copy the JDBC driver appropriate for your database into <db-home>\lib. Remember the database connector contains some pre-installed drivers. So you may be able to skip this step. See the Install a JDBC driver topic.

  4. Restart the connector using one of these methods
    1. Open a command prompt and navigate to the <db-home>\database\database-connector-2.5.0 directory
      1. Type java -jar database.war
    2. Click the Restart-DBConnector-Service.bat to restart  the service for a Windows operating system or execute the Restart - DBConnector.sh shell script for *nix operating systems.

Examples of Datasource Definitions in the configuration.xml file

...