Setup: Oracle SOA Suite and Oracle Database XE
Go Back to main article, "Invoice Processing in a Service-Oriented Environment"
Before getting started, make sure you have Oracle SOA Suite (which includes Oracle JDeveloper) and Oracle Database 10g Express Edition (Oracle Database XE) installed and configured. Follow the steps below to complete this setup.
Preliminary Setup: Oracle Database
Preliminary Setup: Oracle SOA Suite
Preliminary Setup: Database Adapter
Configure a database adapter, which can be used by our ESB flow to perform database-related operations such as insert s and deletes. A database adapter uses a datasource that in turn uses a connection pool to the database.