What is a Multipool used for inside WebLogic?

Robert Castaneda

You can think of a Multipool as a "pool of pools". WebLogic 6.x allows you to create a Multipool and have it mapped to a DataSource.
Multipools support two mutually exlusive algorithms:

  1. Load Balancing - where requests are shared amongst the pools and,
  2. High Availability - where the first pool is used until a fatal exception occurs, then control is passed to the second pool. Note that transaction information is not saved in the event of an error.
The client program is un-aware that a Mutlipool is being used, so there are no coding changes required, it is simply an administration change. Multipools work well with database failover products such as Oracle Parallel Server.