Hi,
We are using Replication and failover with Jboss 5.1.0 GA and mysql 5.1.14 as DB and a J2EE application.
We have configured 2 DB urls(in *-ds.xml). If DB 'A' (assume) goes down app is pointing to DB 'B' (assume). and app points to DB 'B' until B goes down down even though DB 'A' comes up in between app will not point to DB 'A'.
Now i want to change this behaviour. I should have the choice of selecting which DB app has to connect on the fly. Is there any way to do this? can anyone help me out here...
Thanks in advance
Rajesh