Page Comparison

...

1. Stop the Standalone Database Connector.  You can do this by closing the window if you started the DB Connector with the java command or by executing the Stop-DB Connector.(sh,bat) file if you installed it as a service.
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

      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>

      Note
      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

      Code Block
      # 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.
   
   

...