When should I use MultiPools?
If you are using WebLogic Server in a single-server configuration, you can use MultiPools in one of two ways 1) as a backup MultiPool in the event a database connection fails, or 2) as a load balancing MultiPool. Because you can choose only one option, you need to determine the primary purpose of your MultiPool. For more information, see Using Multipools in the Configuring WebLogic JDBC Features section of Programming WebLogic JDBC.
A. You can use MultiPools in one of two ways 1) for high availability in the event a database connection fails, or 2) for load balancing between JDBC connection pools. Because you can choose only one option, you need to determine the primary purpose of your MultiPool. Note: If you implement Multipools for a JDBC application , do not configure driver-level load balancing or failover for the connection pools used by the MultiPool—the MultiPool provides the same functionality as configuring driver-level load balancing or failover. For more information, see “Configuring and Using MultiPools” in Programming WebLogic JDBC.