Skip navigation.

Managing WebLogic Platform Database Resources

  Previous Next vertical dots separating previous/next from contents/index/pdf Contents View as PDF   Get Adobe Reader

Configuring Database Resources

BEA WebLogic Platform delivers a set of integrated administration tools for managing your database resources. This section provides the following guidelines, procedures, and references:


Configuring Database Resources in a Domain

You can configure your database resources as part of the process of creating your domain and/or while your application is running in an existing domain:

If you configure database resources when . . .

Use the . . .

For more information, see . . .

Creating your domain

Configuration Wizard

Configuring a Database Service in Creating WebLogic Platform Configurations Using the Configuration Wizard

Your application is running in an existing domain

WebLogic Server Administration Console

"Configuring Database Connectivity" in WebLogic Server System Administration



Important Recommendations for Configuring WebLogic JDBC

The following table provides some important recommendations for configuring WebLogic JDBC using distributed and local transactions.

If you . . .

Then . . .

Plan to use an XA driver

Configure only one Tx Data Source per XA-compliant JDBC connection pool. Note that you can specify multiple JNDI names per Tx Data Source, separated by semicolons.

Plan to use distributed transactions with non-XA drivers

Configure all Tx Data Sources on the same connection pool.

Plan to use only local transactions

Use a Data Source. Otherwise, use a Tx Data Source, but ensure that you suspend and subsequently resume any global transaction currently associated with your thread around your local transaction boundary.

Start a local transaction

Always commit the transaction. Do not assume autocommit.

Plan to use a JMS JDBC Store

Configure WebLogic JMS on a non-XA JDBC connection pool.

Have created multiple domains

Each domain must reference unique database schemas.


For more information about configuring WebLogic JDBC to use distributed and local transactions, see:


Switching Databases

Note: Before proceeding, review the databases and drivers supported for WebLogic Platform 8.1, as described in Supported Database Configurations in Supported Configurations.

When you install WebLogic Platform, all sample domains, and all the default configuration templates used to create domains, are preconfigured to use the PointBase database. To configure a domain with a database other than PointBase, such as Oracle, see the appropriate instructions.

Optimally, the same enterprise-quality database management system (or an equivalent system) should be used for development and production deployment.


Preparing Your Database for Production

Databases used with the WebLogic Integration, WebLogic Portal, and WebLogic Workshop components of WebLogic Platform require some preparation before they can be delivered for production. For instructions on preparing a database for production, see the following documentation:


Related Topics

The following table provide references to information that may help you manage your database resources.

To learn more about . . .

See . . .

Administration environment: default environment for WebLogic Portal 8.1

The following sections in the WebLogic Portal Database Administration Guide:

Bulk Loader: how to import, export, and delete trading partner management (TPM) data

Using the Trading Partner Bulk Loader in Managing WebLogic Integration Solutions

Database configuration: DB2, MS SQL Server, Oracle9i RAC, Oracle 10g RAC, Sybase

Configuring Databases

JDBC configuration: default

Default JDBC Configurations for WebLogic Platform

Adapters: DBMS sample adapters (J2EE-compliant adapters, each of which includes a JSP-based GUI)

Learning to Develop Adapters Using the DBMS Sample Adapters

CMP entity beans

How Do I: Generate an Entity Bean from a Database Table?

Database controls: how to simplify access to a relational database from your application by using database controls

Database Control

JDBC applications

Programming WebLogic JCBC

dev2dev: Java Database Connectivity (JDBC)

JDBC database stores for WebLogic JMS: how to regenerate existing stores

JDBC Database Utility in Programming WebLogic JMS



Skip navigation bar  Back to Top Previous Next