Skip navigation.
Downloads | Product Documentation | Support

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
- Important Recommendations for Configuring WebLogic JDBC
- Switching Databases
- Preparing Your Database for Production
- Related Topics

# 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:

- Guidelines for Changing to an XA Configuration
- How Do I: Create a Domain Using a Different Database?

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