O'Reilly logo

Oracle Service Bus 11g Development Cookbook by Eric Elzinga, Mischa Kölliker, Jan van Zoggel, Edwin Biemond, Guido Schmutz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required