The database adapter was first introduced in chapter 4. Then we used this adapter to reach out from the Service Bus project or the SOA composite to the database – to invoke PL/SQL stored programs or to query data from tables and views. This adapter also support an inbound mode – where the initiative lies with the adapter instead of with the service. In this section we will use the inbound mode to inspect a table where an external Portal application and an internal application for Saibot’s account managers can write slot requests – database records that represent a desire from an aircraft carrier to take possession of a certain slot.

In this section, we have to develop a SOA composite that will find these slot request records in the database table and process them – making a call to the SlotService for proper registration of the slot allocation in the Future data domain. This composite will poll the table with slot requests. For each record found, a new instance of the SOA composite will be initiated.

Supporting Resources

The sources for the final situation for this section are found in folder InboundProcessing.

DB Adapter Message Throttling in Oracle SOA 11g – Albin Isaac - http://www.albinsblog.com/2012/10/db-adapter-message-throttling-in-oracle.html#.U9qrEGPCdx4

Polling with the DbAdapter in a clustered environment – Maarten Smeets – http://javaoraclesoa.blogspot.nl/2012/04/polling-with-dbadapter-in-clustered.html

Retry and Rollback using DB adapter – SOA Suite 11G – Karan Mann – http://learn-oraclesoa.blogspot.nl/2013/07/retry-and-rollback-using-db-adapter-soa.html

Waslley Souza Blog – Using DB Adapter in SOA Suite 12c

A-Team Chronicles – DB Adapter – Distributed Polling (SKIP LOCKED) Demystified

Documentation

User’s Guide for Technology Adapters Oracle Database Adapter Features-  Performance Tuning