Can someone please point me to some tutorial or "how to" for configuring Jboss to work along with Oracle Data Guard. Motivation behind this is pretty standard, move some of the users to read from the "stand by" database. As this seems to be de facto industry standard i'm not have been able to find any tutorials and best practices on this.
In short all i needed was something like this. Key part here being definition of connection URL:
<connection-url> jdbc:oracle:thin:@(description=(address_list=(load_balance=on)(failover=on)(address=(protocol=tcp)(host=node1-vip)(port=1521))(address=( protocol=tcp)(host=node2-vip)(port=1521)))(connect_data=(service_name=myservice.org.mx) (failover_mode=(type=select)(method=basic)))) </connection-url>
Also in StandBy database there should be links to handle inserts.