0 Replies Latest reply on Nov 8, 2017 4:30 AM by Mohit Sharma

    Abstract jboss persistence based on query type

    Mohit Sharma Newbie



      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