4 JDBC Data Sources Types
Oracle WebLogic Server provides different types of JDBC data sources
such as Generic data source, Multi Data Sources, and so on. You can
configure database connectivity by configuring JDBC data sources and then
targeting or deploying the JDBC resources to servers or clusters in your
WebLogic domain.
- Using the Default Data Source
Oracle provides a default data source required by a Java EE 7-compliant runtime. This pre-configured data source can be used by an application to access the Derby Database installed with WebLogic Server. - Using Generic Data Sources
Generic data sources provide database access and database connection management. Generic data sources and their connection pools provide connection management processes that help keep your system running efficiently. - Using JDBC Multi Data Sources
A Multi Data Source (MDS) is an abstraction around a group of Generic data sources that is bound to the JNDI tree or local application context just like Generic data sources are bound to the JNDI tree. You can configure a MDS to provide load balancing or failover processing at the time of connection requests, between the Generic data sources associated with the MDS. - Using Active GridLink Data Sources
An Active GridLink (AGL) data source provides connectivity between WebLogic Server and an Oracle database. Oracle database offers both on-premises and cloud database services with cluster capabilities of Oracle Grid Infrastructure and Oracle Clusterware. - Using Universal Connection Pool Data Sources
A Universal Connection Pool (UCP) data source is provided as an option for users who wish to use Oracle Universal Connection Pooling to connect to Oracle Databases. UCP provides an alternative connection pooling technology to Oracle WebLogic Server connection pooling. - Using Proxy Data Sources
Proxy data sources provide the ability to switch between databases in a WebLogic Server Multitenant environment.