Hi

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

Thank you

Mohit Sharma