Databases Reference
In-Depth Information
Creating services from databases
Along with files, databases are one of the most common ways of interacting with
existing applications and providing them with a service interface. In this section we
will investigate how to write recordrs into the database using the database adapter.
Writing to a database
Before we configure a database adapter, we first need to create a new database
connection within JDeveloper. This is done by creating a
Database Connection
from the
New Gallery
.
Choosing a database connection brings up the database connection wizard, which
allows us to enter the connection details of our database.
Selecting the database schema
With an established database connection, we can now create a service based on a
database table. We will create a service that updates the database with the payroll
details. The model for the database tables is shown in the following screenshot:
Now that we have our database connection, we can run the Database Adapter Wizard
by dragging the database adapter icon from the tool palette onto a BPEL process or an
SCA Assembly. This starts the Database Adapter Wizard, and after giving the service a
name, we come to the
Service Connection
screen. This is shown as follows:
