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:
- Copy the
org.apache.synapse.poll.dbeventlistener-1.0.0.jar
file to the<EI-HOME>/lib
directory. - Add the required database driver to the
<EI_HOME>/lib
directory based on the database that you want to connect to. - Restart the ESB Profile of WSO2 EI.
Note
If you are using WSO2 ESB, you need to follow the steps below:
- Copy the downloaded JAR file to the
<ESB_HOME>/repository/components/dropins
directory. - Add the required database driver to the
<ESB_HOME>/repository/components/lib
directory based on the database that you want to connect to. - 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.