This documentation is for Live Forms 7.3 Not for you? Earlier documentation is available too.

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 36 Next »



This page describes how to upgrade your Database Connector to v2.5.3+. This upgrade requires you to move your datasource configuration out of configuration.xml and into the <frevvo-home>\tomcat\conf\frevvo-config.properties files.

The database connector v2.5.3+ requires Live Forms server v7.3.2+. See the release notes compatibility matrix.

 On This Page:

Migration Steps - tomcat bundle

  1. Stop
  2. Create a folder named <frevvo-home>\config i.e. c:\frevvo\config. Copy your configuration.xml to this location
  3. Locate & Delete your previous database resource definition(s)
    1. Edit configuration.xml
    2. Delete all lines between and including <resource-def></resource-def> for all querysets

      To help locate this, here is a example of a Datasource definition in configuration.xml

      <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>

    3. Delete all lines between and including <resource-ref></resource-ref>. You would have <resource-ref> definitions in your configuration.xml if you chose to define the database connection in the application container (Tomcat if you are using the frevvo-tomcat bundle) instead of inside the database connector.

      To help locate this, here is an example of a Datasource definition using <resource-ref>.

      <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. Setup your v2.5.3+ database resource definition(s)
    1. Create <frevvo-home>\tomcat\conf\frevvo-config.properties (if it does not already exist in your v7.3.2 frevvo server)

    2. For each deleted <resource-def> lines, Add these lines

      dbconnector.queryset@<your queryset name>.resource-def.url=<the url to your database>
dbconnector.queryset@<your queryset name>.resource-def.user=<your database username>
dbconnector.queryset@<your queryset name>.resource-def.password=<your database password>

    3. For each deleted <resource-ref> lines, Add this line

      dbconnector.queryset@mystore.resource-ref.name=jdbc/<name of your resource>
       Click here for more information

      If you prefer to define your datasources on the container level, the recommended approach is to define the datasource in the container and then use a resource-ref in the Database Connector properties file to reference it..  

      Using <Resource-ref> to define datasources is not supported if you are running the Database Connector in Standalone mode. Use <Resource-def> instead.

      Follow these steps:

      1. Edit <frevvo-home>\tomcat\conf\Catalina\localhost\context.xml.default,

        1. Add the Resource name parameter. An example is shown below:

          <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"/>

      2. Edit frevvo\tomcat\conf\frevvo-config.properties file. Verify that the frevvo.connectors.database.configuration property has been set and add the dbconnector.resource-ref.name property as shown below:

        dbconnector.queryset@<queryset name>.resource-ref.name=jdbc/<name of your resource>

      .

  5. Copy the sample frevvo.connectors.database.configuration property and add it to the frevvo-config.properties file.

  6. Edit the frevvo.connectors.database.configuration line to be the path to your configuration.xml file.

    Sample frevvo.connector.datqbase.configuration property
    frevvo.connectors.database.configuration=file:///C:/frevvo/config/configuration.xml

dbconnector.queryset@<your queryset name>.resource-def.url=<the url to your database>
dbconnector.queryset@<your queryset name>.resource-def.user=<your database username>
dbconnector.queryset@<your queryset name>.resource-def.password=<your database password>
  7. Start Live Forms
  8. Browse http://localhost:8082/database/status. Verify that the query validation page is loaded with status Passed
  9.  Log into your tenant  and test your forms and flows that interact with your database.

Migration Steps - Standalone

  1. Stop the Standalone Database Connector. 
  2. Locate & Delete your previous database resource definition(s)
    1. Edit configuration.xml
    2. Delete all lines between and including <resource-def></resource-def> for all querysets

      To help locate this, here is a example of a Datasource definition in configuration.xml

      <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>

      The use of <resource-ref> definitions is NOT supported when running the Database Connector in standalone mode

  3. Copy the modified configuration.xml file to the <db-home>\database-connector-2.5.x\config .

  4. Copy the JDBC driver for your database into <db-home>\database-connector-2.5.x\lib. Remember the MSSQL driver is included in the standalone database war

  5. Setup your v2.5.3+ database resource definition(s)
    1. Edit the <db-home>\database-connector-2.5.x\conf\dbconnector.properties file

    2. For each deleted <resource-def> lines, Add these lines

      # Customize the DbConnector here
logging.file=./logs/database-connector.%d{yyyy-MM-dd}.log
server.port=8081

dbconnector.queryset@<your queryset name>.resource-def.url=<the url to your database>
dbconnector.queryset@<your queryset name>.resource-def.user=<your database username>
dbconnector.queryset@<your queryset name>.resource-def.password=<your database password>
  6. Restart the connector
    1. Open a command prompt and navigate to the <db-home>\database-connector-2.5.x directory
      1. Type java -jar database.war or click the Restart-DBConnector-Service.bat,sh files if you installed it as a service/daemon
  7. Browse  http://localhost:8081/database/status  Verify that query validation page is loaded with status Passed
  8.  Log into your tenant  and test your forms and flows that interact with your database.

 

 

 

  • No labels