Change the GDBC database driver for an application

Please note that this procedure must be carried out for each application that should be using GDBC.

  1. Access the management pages for the Grid Database Connectivity grid extension. You can access these pages via the grid's Grid Management Pages, which can be accessed through the LifeCycle Manager, Java Web Start, or HTML. For more information, see the Infor ION Grid Administration Guide.
  2. In the Grid Management Pages, click the GDBC application link at the bottom of the page.
  3. On the Application GDBC page, click Configuration.
  4. On the Application: GDBC (GDBC) page, click Edit Properties.
  5. Edit the broker.connectionUrl property:
    1. Click on the Value link for the broker.connectionUrl property and click Add New Entry.
    2. Enter the Grid application name into the Application column, for example, EventHub, CLM or MangoServer (Smart Office server).
    3. Enter the JDBC driver URL connection string into the Value column.

      For example, for a JTDS driver connecting to SQL server, you would use the construct:

      jdbc:jtds:sqlserver://hostname:port/database_name

    4. Select the Merge radio button.
    5. Click Save.
  6. Edit the broker.driverClassName property.
    1. Click on the Value link for the broker.driverClassName property and click Add New Entry.
    2. Enter the Grid application name into the Application column, for example, EventHub, CLM or MangoServer (Smart Office server).
    3. Enter the driver class name into the Value column.

      For example, for a JTDS driver, you would use:

      net.sourceforge.jtds.jdbc.Driver

    4. Select the Merge radio button.
    5. Click Save.
  7. Edit the broker.userName property.
    1. Click on the Value link for the broker.userName property and click Add New Entry.
    2. Enter the Grid application name into the Application column, for example, EventHub, CLM or MangoServer (Smart Office server).
    3. Enter the database user name that should be used for the connection.
    4. Select the Merge radio button.
    5. Click Save.
  8. Edit the broker.password property.
    1. Click on the Value link for the broker.password property and click Add New Entry.
    2. Enter the Grid application name into the Application column, for example, EventHub, CLM or MangoServer (Smart Office server).
    3. Enter the database user's password that should be used for the connection.
    4. Select the Merge radio button.
    5. Click Save.
  9. Edit the broker.driverDirName property.
    1. Click on the Value link for the broker.driverDirName property and click Add New Entry.
    2. Enter the Grid application name into the Application column, for example, EventHub, CLM or MangoServer (Smart Office server).
    3. Enter the driver directory name. This is the Driver Name and can be retrieved from the Drivers page in the GDBC management pages.
    4. Select the Merge radio button.
    5. Click Save.
  10. When you have entered values for the properties, click Save at the top of the Application Properties page and then click Save again on the confirmation dialog box.
  11. Restart the application to put the changes into effect.