Summary

Red Hat JBoss Enterprise Application Platform 6 and 7 use the JDBC API to access databases using JDBC 4.x compliant drivers supplied by database vendors. These drivers must adhere to the JDBC 4.x specification, although some vendors provide additional proprietary features. Fast Connection Failover (FCF) is one of these features.

WebLogic applications enable FCF for JDBC clients by setting the DataSource property FastConnectionFailoverEnabled to TRUE. This allows WebLogic JDBC applications to use connection failover capabilities provided by Oracle Database 10g. This functionality is vendor-specific and not part of the JDBC standard specification.

Implement Oracle Fast Connection Failover (FCF) in JBoss EAP

To gain access to Oracle's connection caching and FCF with Oracle RAC, you must use Oracle Universal Connection Pool (UCP). Oracle's UCP has not been tested or certified by Red Hat is not supported in JBoss EAP.

However, JBoss EAP does provide support for load-balancing and failover with Oracle RAC by using vendor-special features that are transparent to the application server to which they are deployed. For example, you can supply a detailed URL to the Oracle JDBC driver and the driver will provide transparent load-balancing and fail-over. The following is an example URL that provides load-balancing and fail-over.

<xa-datasource-property name="URL">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=my.host1.org)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=my.host2.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=servjboss)(failover_mode=(type=select)(method=basic)))</xa-datasource-property>

For more information, see Use Oracle FCF in JBoss EAP.