how to config oralce-ds.xml for realize the oracle rac fast connection faiover

Posted Mon, 14/06/2010 - 11:10 by michael.yavorovsky
, , , , ,

I'm not clear on how to enable Fast Connection Failover with JBoss. Basically FCF is configurable  by OracleDataSource.setFastConnectionFailoverEnabled(true); on a DataSource instance before retrieving any connections from that instance. But standart JBoss datasource xml configuration doesn't provide such settings.

‹ moving from java 5 to java 6 or 7 Apache FTP Client - abort transfer ›

Comments

by itai - 14/06/2010 - 13:08

set the URL section in oracle-ds.xml

<url>jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=off)(FAILOVER=on)(ADDRESS_LIST=(ADDRESS=(protocol=tcp)(host=node1-vip)(port=1521))(ADDRESS=(protocol=tcp)
(host=node2-vip)(port=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=racdb)))</url>

by michael.yavorovsky - 14/06/2010 - 14:47

As far as I understand this enables the failover mechanism, but not the FCF (Fast Connection Failover). Am i right?

by michael.yavorovsky - 14/06/2010 - 18:20

Bad news:

JBOSS does not support FCF out of the box through it's data source implementation. So the only way to do this is to use the 10.2.0.4 JDBC driver, and manually make use of the Implicit Connection Cache as shown by these 2 references below. As a result of this you won't be able to use a data source in JBOSS but instead code it manually.