In order to have fail-over work with Oracle RAC, i guess i have to use FCF (fast connection failover mechanism).
This essentially involves including ons.jar, and setting properties on your datasource.
I believe Tomcat datasource there are specific params you can set, like as follows:
<Resource ....
...
ONSConfiguration="nodes=rac1:6200,rac2:6200"
fastConnectionFailoverEnabled="true"
implicitCachingEnabled="true"
..
/>
I am not able to find any example or documentation on how to do the equivalent thing for JBoss Datasource.
Any advice?
There is no special support for this in JBoss.
You need to add a datasource with a thin or OCI driver and set the appropriate connect parameter for Oracle.