Databases Reference
In-Depth Information
Configuring global JDBC data source
When an ADF application connects to a database, it does this via a JDBC URL or
JDBC data source, which can be defined either globally or at the application level.
To enable the SDO to participate as part of the BPEL transaction, we need to deploy
the corresponding ADF-BC component configured to use a global JDBC data source,
which, in turn, is configured to support distributed transactions.
When we create our ADF-BC project, JDeveloper automatically defines a number
of application-level database connections: a couple of JDBC URL connections and
an application level JDBC data source. By default, these application-level data
connections will be packaged and deployed along with the ADF-BC component,
meaning that, at runtime, the ADF application will connect directly to the database
using the JDBC URL (ignoring any global JDBC data source defined to the
WebLogic server).
To prevent this, right-click on the
ListingSDO
application, select
Application
Properties
to open the corresponding window, and select
Deployment
from the
navigation tree. Then deselect the option
Auto Generate and Synchronize
weblogic-jdbc.xml Descriptors During Deployment
, which is circled in the
following screenshot:
