Book Image

Oracle Service Bus 11g Development Cookbook

Book Image

Oracle Service Bus 11g Development Cookbook

Overview of this book

Oracle Service Bus 11g is a scalable SOA integration platform that delivers an efficient, standards-based infrastructure for high-volume, mission critical SOA environments. It is designed to connect, mediate, and manage interactions between heterogeneous services, legacy applications, packaged solutions and multiple Enterprise Service Bus (ESB) instances across an enterprise-wide service network. Oracle Service Bus is a core component in the Oracle SOA Suite as a backbone for SOA messaging. This practical cookbook shows you how to develop service and message-oriented (integration) solutions on the Oracle Service Bus 11g. Packed with over 80 task-based and immediately reusable recipes, this book starts by showing you how to create a basic OSB service and work efficiently and effectively with OSB. The book then dives into topics such as messaging with JMS transport, using EJB and JEJB transport, HTTP transport and Poller transports, communicating with the database, communicating with SOA Suite and Reliable Message Processing amongst others. The last two chapters discuss how to achieve message and transport-level security on the OSB.
Table of Contents (19 chapters)
Oracle Service Bus 11g Development Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Introduction


In this chapter, we will show two different mechanisms to talk to the database:

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

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