I have a datasource configured in MySQL-ds.xml and the datasource is being used by the application using JNDI.
The scenario here is to separate out calls for SELECT and (INSERT,UPDATE). I would like to route SELECT to a different MySQL instance and (INSERT,UPDATE) to a different MySQL instance 2.
Now As this is a special case and also the application is a legacy app which needs an upgrade, I need help in doing so, is there anything I can use a hack or a hook?
Jboss version: 4.3.2
MySQL version 5.1
Retrieving data ...