Skip navigation.
Downloads | Product Documentation | Support

Administration Console Online Help

# Create JDBC data source factories

Before you begin

Make sure that the JDBC drivers that you want to use to create database connections are installed on all servers on which you want to deploy application-scoped data sources and connection pools. Some JDBC drivers are installed with WebLogic Server, including BEA WebLogic Type 4 JDBC drivers for DB2, Informix, MS SQL Server, Oracle, and Sybase. For more information about working with JDBC drivers, see Using Third-Party JDBC Drivers with WebLogic Server

If your applications were developed for previous WebLogic Server releases and they contain application-scoped JDBC data sources and connection pools, you may need to create data source factories. Data source factories are used to create the legacy application-scoped data sources and connection pools when you deploy your applications. Data source factories also supply some default values for connections in the application-scoped connection pools.

Note: Data source factories are deprecated. They are included in this WebLogic Server release for backward compatability only.

To create a JDBC data source factory:

1. If you have not already done so, in the Change Center of the Administration Console, click Lock & Edit (see Use the Change Center).
2. In the Domain Structure tree, expand Services > JDBC, then select Data Source Factories.
3. On the Summary of JDBC Data Source Factories page, click New.
4. On the JDBC Data Source Factory Properties page, enter:

   Name - Enter a name for this JDBC data source factory. This name is used in the configuration file (`config.xml`) and throughout the Administration Console whenever referring to this data source factory.

   Database User Name - Enter the database user account name that you want to use for each connection in data sources created from this data source factory.

   Password - Enter the password for the database user acccount.

   URL - Enter the URL of the database to use when creating physical database connections.

   Driver Class Name - Enter the full path name of the JDBC driver to use when creating physical database connections. The driver must be in the server classpath.

   Factory Name - Enter the name to use when referring to this factory in descriptor files.

5. Click OK to save the JDBC data source factory configuration and deploy the data source to the targets that you selected.
6. To activate these changes, in the Change Center of the Administration Console, click Activate Changes.
   Not all changes take effect immediately—some require a restart (see Use the Change Center).