Versions Compared

Old Version 7

changes.mady.by.user Former user

Saved on

compared with

New Version 8

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

...

Code Block
<resource-def>
    <url>YOUR database Url HERE</url>   
    <driver>YOUR driver HERE</driver>
    <user>YOUR database user HERE</user>
    <password>YOUR password HERE</password>
</resource-def>

Using the v2.4 configuration.xml file that contains <resource-ref> with the v2.5 connector

There is an alternate approach that defines the database connection in the application container (Tomcat if you are using the frevvo-tomcat bundle) instead of inside the database connector. To use this approach:

  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.

  2. Define a <resource> as shown below. The XML samples below assume a MySql database driver. You will need to replace this sample values to match your database type.

    This is the format of the <resource> element in context.xml.default.

     



    Code Block
    <Resource name="jdbc/mystore_ds"
          auth="Container"
          factory="org.apache.commons.dbcp.BasicDataSourceFactory"            
          driverClassName="com.mysql.jdbc.Driver"
          username="YOUR database user HERE"
          password="YOUR database password HERE"
          type="javax.sql.DataSource"
          url="jdbc:mysql://localhost/mystore?autoconnect=true"/>

     

    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>

  3. Replace the <resource-def> element in your configuration.xml with a <resource-ref> element as shown below.

    Code Block
    <resource-ref>
    <description>MySQL Customers</description>
    <res-ref-name>jdbc/mystore_ds</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
</resource-ref>
  4. Verify that the resource-ref is defined in your configuration.xml file for each queryset.
  5. 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

...