Oracle Service Bus 11g Development Cookbook

Chapter 7. Communicating with the Database

In this chapter, we will cover:

• Using DB adapter to read from a database table
• Using DB adapter to execute a custom SQL statement against the database
• Using DB adapter to update a database table
• Using DB adapter to poll for changes on a database the table
• Using the AQ adapter to consume messages from database
• Using the AQ adapter to send messages to the database

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