Managing WebLogic Platform Database Resources

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:

FAQs: WebLogic JDBC
FAQs: JTA
Guidelines for Changing to an XA Configuration in Creating WebLogic Configurations Using the Configuration Wizard

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.

For information that applies to all domains, see the following information in Creating WebLogic Configurations Using the Configuration Wizard:

For information specific to WebLogic Portal domains, see:

Using a Microsoft SQL Server Database in WebLogic Portal Database Administration Guide
Using an Oracle Database in WebLogic Portal Database Administration Guide
Using a Sybase Database in WebLogic Portal Database Administration Guide
Using a DB2 Database in WebLogic Portal Database Administration Guide
How Do I: Create a Domain Using a Database with an XA Driver? in Creating WebLogic Configurations Using the Configuration Wizard

For information specific to WebLogic Integration domains, see:

How Do I: Create a Domain Using a Database with an XA Driver? in Creating WebLogic Configurations Using the Configuration Wizard

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:

WebLogic Integration — See Configuring a Production Database in Managing WebLogic Integrations Solutions.
WebLogic Portal — See the chapter about your database type in Database Administration Guide.
WebLogic Workshop — See "To Manually Create Required Resources on the Production Server" in How Do I: Deploy a WebLogic Workshop Application to a Production Server? in the WebLogic Workshop Online Help.
WebLogic Platform — See Configuring the Production Database in Deploying WebLogic Platform Applications.

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: Overview of Database Administration for WebLogic Portal Data Dictionary
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
JDBC applications	dev2dev: Java Database Connectivity (JDBC)
JDBC database stores for WebLogic JMS: how to regenerate existing stores	JDBC Database Utility in Programming WebLogic JMS