[jboss-user] [JCA/JBoss] - Re: database failover for ejb application (persistance.xml p

[vickyk]

"grdzeli_kaci" wrote : 
  | may i use ha-xa-datasources and implement ConnectionChecker and ExceptionSorter classes or simple add multiple DS into my -ds.xml file ?
  | 
You are completely going in a wrong direction 
All you have to do is to configure multiple DS in JBoss which can be done by having multiple -ds.xml file .
In the MDB onMessage() you would need to have 

  | onMessage(...){
  | InitialContext context = new InitialContext();
  | DataSource ds ;
  | if(condition1)
  | ds=(DataSource)context.lookup("ds1");
  | else if(condition2)
  | ds=(DataSource)context.lookup("ds1");
  | ......................
  | }
  | 

You finally made me help in DOING Code for you :(


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4082063#4082063

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4082063