Hello,
Since its version 7.0, WebSphere Application Server supports Oracle Universal Connection Pool (UCP) (See http://www-01.ibm.com/support/docview.wss?uid=swg1PM44388).
UCP supports setting *transaction-based affinity* or *web-session* affinity for Oracle RAC connections. Connection affinity can improve performance of DB transactions.
The only way to setup affinity on UCP is by registering an affinity callback on the UCP data source. (see http://docs.oracle.com/cd/E11882_01/java.112/e12265/rac.htm#CHDCIHED)
I did *not* find a way to setup affinity via data source configuration properties.
This means that the either the application server has to implement the affinity callback classes or the application has to implement them.
It is known that WebLogic Server implements the affinity callback classes so that applications do not have to write additional Java code.
Does anyone know whether WebSphere Application Server implement the affinity callback classes? Or does WebSphere expect applications to implement the callbacks (which is not trivial)?
I did not find WebSphere documentation which clarifies this.
Regards,
Rahul