JBoss Datasource HA

This tutorial has been updated for the new release of JBoss Application Server. We’ll discuss about High availability Datasources.

A High availability data source is an abstraction around a group of data sources that provides failover processing between a list of data source. High availability data sources are bound to the JNDI tree or local application context just like data sources are bound to the JNDI tree.  

When you configure an HA Datasource you can choose a list of Connection URL- when the Connection you are using is not available anymore, the connection factory will (transparently to the user) choose another database connection URL, try to allocate a connection using it and, in case of success, return the connection back to the user.

jboss HA Datasource 

Configuring an HA Datasource is a matter of a few steps:

1. Check that resource adapters are deployed

In order to use HA Datasource you need a specialized version of the Connection factory: depending if you use local or XA transaction you would need the files jboss-ha-local-jdbc.rar and jboss-ha-xa-jdbc.rar packages.

jboss datasource

In recent versions of JBoss this files are already deployed under the “default” configuration. In older release you can find the Resource Adapters under JBOSS_HOME/docs/examples/jca 

2. Create the DataSource Configuration file.

The configuration file for an HA datasource isnot much different from an ordinary datasource file, what makes the trick is the “<url-delimiter>” which separates the list of Connection-urls.
So here’s a configuration for a Local HA Datasource with an Oracle driver class:

<?xml version="1.0" encoding="UTF-8"?>   
   <!-- list of connection URLs -->      
   <!-- The driver class -->      
   <!-- this will be run before a managed connection is removed from the pool for use by a client-->     
   <check-valid-connection-sql>select count(*) from testable</check-valid-connection-sql>   

If on the other hand you need to configure an XA HA Datasource, you can use the following template:

 <!-- This disables transaction interleaving (which BTW,most DB vendors don't support) -->       <track-connection-by-tx></track-connection-by-tx>       
 <!-- list of connection URLs -->       
 <xa-datasource-property name="URL">jdbc:oracle:thin:@oraclehost:1521:SID|jdbc:oracle:thin:@oraclehost:1521:SID2</xa-datasource-property>       
 <check-valid-connection-sql>VALUES CURRENT TIMESTAMP</check-valid-connection-sql>    

What happens if one connection fails ?

When a Connection is no longer available JBoss warns you about it and picks up the next Connection from the list using the Round-Robin Algorithm.


15:20:01,234 WARN  [HALocalManagedConnectionFactory] Failed to create connection  for jdbc:oracle:thin:@oraclehost:1521:SID: IO Exception : The Network Adapter could not establish the connection

JBoss 5 High Availability Datasource

JBoss 5 has changed the configuration for HA Datasources. You don’t have anymore
<ha-local-tx-datasource> or  <ha-xa-datasource> Element. Simply use a Connection URL with a list of Connections separated by an URL Delimiter.
Here’s an example for an XA-Datasource:




    <check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>





Also, in the new Application Server release you don’t have any more jboss-ha-local-jdbc.rar and jboss-ha-xa-jdbc.rar.

The logic contained in Classes HALocalManagedConnectionFactory and  HAXAManagedConnectionFactory has been transferred directly in the standard XA/Local ManagedConnectionFactory