O'Reilly logo

Oracle Service Bus 11g Development Cookbook by Eric Elzinga, Mischa Kölliker, Jan van Zoggel, Edwin Biemond, Guido Schmutz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required