Weblogic JDBC- Multipool

WebLogic JDBC - MultiPool

•         MultiPool

 This is a pool of connection Pools. The pools can be connected to different DBMS or specific setup like Oracle RAC.

   

    You would need to choose the algorithm based on application requirements (Only one algorithm can be applied)

High Availability: All connection requests are served from first pool in the list. *Only* if the pool is not available, (connection fails and cannot be refreshed) the connection is routed to the next pool in the list.

Loadbalacing:

Connection requests to the pool are roundrobined across the list of pools. However if a connection request to a connection pool

was not successful and cannot be recreated (such as when DB is down or pool is suspended) then the request is routed to next connection pool in the list.

Oracle RAC:

The multipool concept can be applied to Oracle RAC where each connection pool is connected to one of the oracle instance and we can choose the algorithm.

There are quite a few limitations to multipool when global transactions are involved (XA).