We try to use

<datasource ... >
<connection-url>jdbc:sqlserver://SERVER_ONE:1433;databaseName=MyDB|jdbc:sqlserver://SERVER_TWO:1433;databaseName=MyDB</connection-url>
<url-delimiter>|</url-delimiter>
...
</datasource>

to treate database failover case, but it doesn't work in JBoss 7.1.0.CR1. It just use the first connection url.

By looking at the code source of jboss connector ( in org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService.java), I found the url-delimiter's value is never set into LocalManagedConnectionFactory.