Database Reference
In-Depth Information
nel and host of an MQ Server or the data source information for a database ad-
apter) required by the adapter to access the backend information source.
Our order booking composite saves order events in a database through a Data-
base Adapter. After the composite is deployed to the SOA Infrastructure, the
adapter JNDI needs to be associated with a valid data source configured for a
database. To do so follow these steps:
1.
Log in to Oracle Weblogic Server Administration Console.
2.
Click on
Deployments
under the
Your Deployed Resources
section.
3.
From the list of all available deployments, click on
DbAdapter
and navigate
to
Configuration
|
Outbound Connection Pools
.
4.
Click on the
New
button and create a new outbound connection instance.
Remember, the JNDI name that is used here should be the same one that
was defined for the reference at design time.
5.
Expand
javax.resources.cci.ConnectionFactory
to see all the JNDI
names that are configured for the adapter to communicate with databases.
Click on the one that was created in step 4.
6.
In the
Properties
tab, you would see properties such as
xADataSourceName
and
dataSourceName
. Enter the name of the actual
data source that has a connection defined for the database in any of these
properties.
7.
Save the changes.
8.
From the list of deployments, select
DbAdapter
, and click on
Update
. This
propagates the resource adapter changes to be persisted in the deployment
properties (saved in the
Plan.xml
files).
It is important that you specify only one data source for
the
DbAdapter
JNDI property. If an XA compliant data
source is created, your adapter's outbound connection
pool JNDI location should define the value under the
