Technical data

16 Managing JDBC Connectivity
16-14 Administration Guide
Configuring XA JDBC Drivers for Distributed
Transactions
To allow XA JDBC drivers to participate in distributed transactions, configure the
JDBC Connection Pool as follows:
n Specify the Driver Classname attribute as the name of the class supporting the
javax.sql.XADataSource interface.
n Make sure that the database properties are specified. These properties are passed
to the specified
XADataSource as data source properties. For more information
on data source properties for the WebLogic jDriver for Oracle, see “WebLogic
jDriver for Oracle/XA Data Source Properties.” For information about data
source properties for third-party drivers, see the vendor documentation.
n See “Additional XA Connection Pool Properties” on page 16-20 for any
additional connection pool properties that may be required to support XA for
your DBMS.
The following attributes are an example of a JDBC Connection Pool configuration
using the WebLogic jDriver for Oracle in XA mode.
Table 16-8 WebLogic jDriver for Oracle/XA: Connection Pool Configuration
Attribute
Name Attribute Value
Name
fundsXferAppPool
Targets
myserver
DriverClassname
weblogic.jdbc.oci.xa.XADataSource
Initial Capacity
0
MaxCapacity
5
CapacityIncrement
1
Properties
user=scott
password=tiger
server=localdb