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:

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 tables created with the OSB Cookbook standard environment. Make sure that the connection factory is set up in the database adapter configuration, as shown in the Introduction of this chapter.

You can import the OSB project containing the base setup for this recipe into Eclipse from \chapter-7\getting-ready\using-db-adapter-to-poll-for-changes...