Administration Console Online Help

Previous Next Open TOC in new window
Content starts here

Configure database connectivity

In WebLogic Server, you configure database connectivity through JDBC data sources, either in your WebLogic domain configuration or in your enterprise application. A data source is a J2EE standard method of configuring connectivity to a database. Each WebLogic data source contains a pool of database connections. Applications look up the data source on the JNDI tree or in the local application context and then use a database connection from the pool of connections. Data sources and their connection pools provide connection management processes that help keep your system running efficiently.

You can optionally configure multi data sources, which provide load balancing and failover management between data sources.

If your applications were developed for previous WebLogic Server releases and they contain application-scoped JDBC data sources and connection pools, you may also 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 that data source factories are deprecated. They are included in this WebLogic Server release for backward compatibility only.

The main steps for configuring database connectivity are:

  1. 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 configure database connectivity. Some JDBC drivers are installed with WebLogic Server, including the Oracle Type 4 JDBC drivers for DB2, Informix, MS SQL Server, and Sybase. For more information about working with JDBC drivers, see Using JDBC Drivers with WebLogic Server.
  2. Create a data source for each data base that you want to connect to. If you need more than one set of configuration options for a database, you can create more than one data source that includes connections to the same database. See Create JDBC generic data sources.
  3. Optionally create multi data sources to provide load balancing or failover between generic data sources in your configuration. See Create JDBC multi data sources.
  4. Optionally, create data source factories to support application-scoped connection pools included in applications created for previous versions of WebLogic Server. See Create JDBC data source factories.

Related Topics

Back to Top