Recently I was visiting a customer in Korea and there was this interesting topic on when to use Multidatasources in WebLogic and why not use a single Datasource with SCAN IP for the Oracle RAC Cluster behind.
Well there are 2 ways to look at it.
Do you need GRID capabilities of horizontal scaling up and down??? You better go for a single Datasource with SCANIP instead of VIPs
Is your environment sized and future proof in terms of volume(well almost…) and you don’t have more to spend on Databases??? You have the Multidatasource
Off course you need to also see the best practices on the application you are running on WebLogic if they are COTS.
Still there are some advantages:
Weblogic drivers for RAC enabled XA connectivity to Oracle DB is superb and by far the best driver to use.
Weblogic takes care of connection handling and liaising with multiple pools of connections and it is a MAA architecture model
It can do Load Balancing for you!!!
Comments, if you have any…