I have similar problem i am using 2 war files and one ear file. For for every database instance-service.xml file. I have created 2 host using DNS but i am able to connect to only one database. I want every instance should use seperate database. Do u found any solution to this issue ?
anyone else manged to find a way round this ?