[jboss-user] [Datasource Configuration] - How to configure Oracle Datasource (oracle-ds.xml) for FCF (Fast Connection Failover) for Oracle RAC?

[jasper2000]

jasper2000 [https://community.jboss.org/people/jasper2000] created the discussion

"How to configure Oracle Datasource (oracle-ds.xml) for FCF (Fast Connection Failover) for Oracle RAC?"

To view the discussion, visit: https://community.jboss.org/message/831286#831286

--------------------------------------------------------------
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?
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/831286#831286]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

[Wolf-Dieter Fink]

Wolf-Dieter Fink [https://community.jboss.org/people/wdfink] created the discussion

"Re: How to configure Oracle Datasource (oracle-ds.xml) for FCF (Fast Connection Failover) for Oracle RAC?"

To view the discussion, visit: https://community.jboss.org/message/831414#831414

--------------------------------------------------------------
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.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/831414#831414]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]