This site contains the documentation that is relevant to older WSO2 product versions and offerings.
For the latest WSO2 documentation, visit https://wso2.com/documentation/.

DB Event Listener

The DB event listener supported by WSO2 Enterprise Integrator is a polling inbound endpoint that allows you to monitor changes done to records in a database table.

Configuring the DB event listener

To get started, you need to download the DB event listener JAR file.

To download the DB event listener JAR file, go to https://store.wso2.com/store/assets/esbconnector/DBEventListener, and click Download Streaming Connector. This downloads the org.apache.synapse.poll.dbeventlistener-1.0.0.jar file. 

To use the DB event listener with WSO2 Enterprise Integrator (WSO2 EI), you need to follow the steps below:

  1. Copy the org.apache.synapse.poll.dbeventlistener-1.0.0.jar file to the <EI-HOME>/lib directory.
  2. Add the required database driver to the <EI_HOME>/lib directory based on the database that you want to connect to.
  3. Restart the ESB Profile of WSO2 EI.

Note

If you are using WSO2 ESB, you need to follow the steps below:

  1. Copy the downloaded JAR file to the <ESB_HOME>/repository/components/dropins directory.
  2. Add the required database driver to the <ESB_HOME>/repository/components/lib directory based on the database that you want to connect to.
  3. Restart your ESB instance.

Now that you have configured the DB event listener, see Working with the DB Event Listener for information on how to use the DB event listener to monitor and log changes done to records in a database table.