Adding a JDBC connection (Windows)

You may require a JDBC connection when you need create your XML message using columns from other tables.

About this task

After adding the required JDBC driver and connection using the configuration tool, when you create an XML message in Management Console, you can access the other database and retrieve these columns using SQL statements.

Procedure

  1. Launch the configuration tool at the command prompt by issuing the following command in the specified directory: 
    \<CDC Replication installation directory>\bin\dmconfigurets.exe
  2. Ensure you have stopped the CDC Replication Engine for Event Server service.
  3. Ensure you have added the correct JDBC driver so that CDC Replication can connect to the appropriate database. You can add third party libraries in the Environment tab.
  4. Select an existing CDC Replication instance that you have added and click Edit.
  5. Enter the name of the driver in the Name box. The following name is an example: com.pointbase.jdbc.jdbcUniversalDriver.
  6. Click Select.
  7. Enable Use the JDBC-ODBC bridge driver and click OK.
  8. Verify the database URL in the URL box. A JDBC URL is unique among all drivers. Each database can have one or more subprotocols. All JDBC driver URLs start with the JDBC protocol, and are followed by the vendor-specific sub-protocol. The third part is different for each driver. Common URL patterns matching the driver are provided in the driver list box. For more information, consult the documentation from your driver vendor. The following example uses the JDBC-ODBC Bridge Driver from Sun and the name of the data source is mySource.

    Driver: sun.jdbc.odbc.JdbcOdbcDriver

    URL: jdbc:odbc:mySource

  9. Enter the user name of a valid user account to access the database.
  10. If the database requires authentication, enter and confirm the password in the Password and Confirm Password boxes.
  11. Enter a description for this connection in the Description box.
  12. Enter the schemas that you can access in the Schemas box. These must be separated by commas (for example: sys,scott,joe).
  13. Click Test to verify the connection.
  14. Click OK.