UCP Support For Connection Affinity
Has anyone tried out & understood this feature support from [oracle's universal connection pool|http://docs.oracle.com/cd/E11882_01/java.112/e12265/rac.htm#CHDCIHED] (UCP)?
I didn't quite understand what does connection affinity means, how does it actually work & the differences between transaction, web based and data based affinity? To be specific I would appreciate thoughts on the below questions which I came across after reading the documentation.
1. "Transaction-based affinity is an affinity to an Oracle RAC instance that can be released by either the client application or a failure event." Isn't affinity an hint from the Oracle RAC instance to the connection pool?
2. How does the connection pool implement Web based affinity?
3. What does long & short lived affinity mean?
4. UCP 11.2.0.1.0 provides data based connection affinity too. How is it implemented?
5. When is the affinity callback instance called by the connection pool?
I observed that the feature support works with ucp 11.2.0.1.0.