Technical data

16 Managing JDBC Connectivity
16-10 Administration Guide
javax.transaction.xa.XAResource), including the WebLogic jDriver for
Oracle/XA.
n Any JDBC driver that supports JDBC 2.0 Core API but does not support JDBC
2.0 distributed transactions standard extension interfaces. Only one non-XA
JDBC driver at a time can participate in a distributed transaction. See
“Configuring Non-XA JDBC Drivers for Distributed Transactions” on page
16-20.
Configuring JDBC Drivers for Local Transactions
To configure JDBC drivers for local transactions, set up the JDBC Connection Pool as
follows:
n Specify the Driver Classname attribute as the name of the class supporting the
java.sql.Driver interface.
n Specify the database properties. These properties are passed to the specific driver
as driver properties.
In the Administration Console, you specify connection properties as a name=value pair
with each property on its own line. In the configuration file (
config.xml), connection
properties are listed in a string separated by semicolons. For example:
Properties="user=SCOTT;server=DEMO"
For more information on WebLogic two-tier JDBC drivers, refer to the BEA
documentation for the specific driver you are using: Installing and Using WebLogic
jDriver for Oracle at http://e-docs.bea.com/wls/docs61/oracle/index.html, Installing
and Using WebLogic jDriver for Microsoft SQL Server at
http://e-docs.bea.com/wls/docs61/mssqlserver4/index.html, or Installing and Using
WebLogic jDriver for Informix at
http://e-docs.bea.com/wls/docs61/informix4/index.html. If you are using a third-party
driver, refer to Using Third-Party JDBC XA Drivers with WebLogic Server in
Programming WebLogic JTA at
http://e-docs.bea.com/wls/docs61/jta/thirdpartytx.html and the vendor-specific
documentation. The following tables show sample JDBC Connection Pool and Data
Source configurations using the WebLogic jDrivers.
The following table shows a sample Connection Pool configuration using the
WebLogic jDriver for Oracle.