Technical data

JDBC Configuration Guidelines for Connection Pools, MultiPools and DataSources
Administration Guide 16-9
n Use the Java Transaction API (JTA)
n Use the EJB container in WebLogic Server to manage transactions
n Include multiple database updates within a single transaction
n Access multiple resources, such as a database and the Java Messaging Service
(JMS), during a transaction
n Use the same connection pool on multiple servers
With an EJB architecture, it is common for multiple EJBs that are doing database work
to be invoked as part of a single transaction. Without XA, the only way for this to work
is if all transaction participants use the exact same database connection. WebLogic
Server uses the JTS driver and a TxDataSource (with Enable Two-Phase Commit
selected) to do this behind the scenes without requiring you to explicitly pass the JDBC
connection from EJB to EJB. With XA (requires an XA driver), you can use a Tx Data
Source in WebLogic Server for distributed transactions with two-phase commit so that
EJBs can use a different database connections for each part of the transaction. In either
case (with or without XA), you should use a Tx Data Source.
Read more about Data Sources in Programming WebLogic JDBC at
http://e-docs.bea.com/wls/docs61/jdbc/programming.html.
Note: Do not create two Tx Data Sources that point to the same connection pool. If
a transaction uses two different Tx Data Sources which are both pointed to the
same connection pool, you will get an XA_PROTO error when you try to
access the second connection.
Drivers Supported for Local Transactions
n JDBC 2.0 drivers that support the JDBC Core 2.0 API (java.sql), including
the WebLogic jDrivers for Oracle, Microsoft SQL Server, and Informix. The
API allows you to create the class objects necessary to establish a connection
with a data source, send queries and update statements to the data source, and
process the results.
Drivers Supported for Distributed Transactions
n Any JDBC 2.0 driver that supports JDBC 2.0 distributed transactions standard
extension interfaces (
javax.sql.XADataSource, javax.sql.XAConnection,