Change the GDBC database driver for an application

Note: 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 through the grid's Grid Management Pages, which in turn is accessible 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 the Value link for the broker.connectionUrl property and click Add New Entry.
    2. Specify the Grid application name into the Application column, for example, EventHub, CLM or MangoServer (Smart Office server).
    3. Specify 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 the Value link for the broker.driverClassName property and click Add New Entry.
    2. Specify the Grid application name into the Application column, for example, EventHub, CLM or MangoServer (Smart Office server).
    3. Specify 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 the Value link for the broker.userName property and click Add New Entry.
    2. Specify the Grid application name into the Application column, for example, EventHub, CLM or MangoServer (Smart Office server).
    3. Specify 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 the Value link for the broker.password property and click Add New Entry.
    2. Specify the Grid application name into the Application column, for example, EventHub, CLM or MangoServer (Smart Office server).
    3. Specify 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 the Value link for the broker.driverDirName property and click Add New Entry.
    2. Specify the Grid application name into the Application column, for example, EventHub, CLM or MangoServer (Smart Office server).
    3. Specify the driver directory name. This is the Driver Name and is retrieved from the Drivers page in the GDBC management pages.
    4. Select the Merge radio button.
    5. Click Save.
  10. When you have specified 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.