Hello there!
I have JBoss 7.1.1 and two Postgres database hosts on 192.168.0.1 and 192.168.0.2
My config:
...
<datasource jndi-name="java:/RevolutionDS" pool-name="RevolutionDS" enabled="true" use-java-context="true" use-ccm="false">
<connection-url>jdbc:postgresql://192.168.0.1:5432/revolution|jdbc:postgresql://192.168.0.2:5432/revolution</connection-url>
<driver>org.postgresql.xa</driver>
<url-delimiter>|</url-delimiter>
<security>
<user-name>revolution</user-name>
<password>revolution</password>
</security>
</datasource>
...
<drivers>
<driver name="h2" module="com.h2database.h2">
<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
</driver>
<driver name="org.postgresql" module="org.postgresql">
<driver-class>org.postgresql.Driver</driver-class>
</driver>
<driver name="org.postgresql.xa" module="org.postgresql">
<xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
</driver>
</drivers>
...
If databases on on 192.168.0.1 and 192.168.0.2 available, everything works fine. But if I stop database on 192.168.0.1 error occurs. If I restart JBoss with stopped database on 192.168.0.1 (and available on 192.168.0.2) everything ok.
Please help...