Using DB adapter to poll for changes on a database table

In this recipe, we will use the setup of the previous recipe and implement an inbound DB adapter. The DB adapter allows triggering execution of a proxy service upon changes on a table by using polling. The adapter is capable of marking or deleting read and processed rows in several ways. We will implement a proxy service which consumes from a DB adapter, as shown in the following screenshot:

Using DB adapter to poll for changes on a database table

For the configuration of the DB Adapter we will use JDeveloper and then switch to Eclipse to implement the proxy service wrapping the inbound DB adapter.

Getting ready

For this recipe, we will use the database ...

Get Oracle Service Bus 11g Development Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.