Database Reference
In-Depth Information
Database Adapter
The Oracle Database Adapter enables a BPEL process to communicate with Oracle
databases or any third-party databases such as MS SQL and MySQL through JDBC
drivers. One can use a vendor's database for design time and another for runtime
because BPEL processes are database-platform neutral.
In order to leverage Database Adapter to create composite web services, one needs
to establish database connections. One can establish all the database connections
by navigating to
File
|
New
|
Connections
, or alternatively one can create data-
base connections on step 3 of the Adapter Configuration Wizard. In order to create
a database connection, you need to provide the database details such as
Connec-
tion Type
,
Username
,
Password
,
Host Name
,
JDBC port
, and
Service Name
, as
shown in the following screenshot:
