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

    Abstract jboss persistence based on query type

    Mohit Sharma Newbie

      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