Introduction
In this chapter, we will show two different mechanisms to talk to the database:
Using the DB adapter: It enables the OSB to communicate with database endpoints, such as Oracle database servers and any relational databases that provide JDBC drivers. Allows the execution of SQL statements, such as select, insert, updating, deleting as well as calling stored procedures or functions. Can also be used inbound, by polling for changes on a database table.
Using the AQ adapter: It enables the OSB to talk to the Oracle Advanced Queuing (AQ) feature of an Oracle database. Oracle AQ offers queuing inside the database and is often used to implement asynchronous communication between applications in the database.
Both the DB adapter and the AQ adapter are JCA adapters and are well-known from the Oracle SOA Suite. As OSB 11g, they are also integrated with the OSB through the JCA transport.
The configuration of the JCA adapters is not available in Eclipse OEPE. For that, we have to use JDeveloper...
