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 Java EE 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.

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 WebLogic-branded Data Direct 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.

Related Topics

Back to Top