1 Reply Latest reply on Sep 17, 2002 3:04 PM by Sloan Seaman

    Using different datasources

    Sloan Seaman Newbie

      I have two datasources defined, one for MySQL and one for MSSQL.

      One application needs to use MySQL while the other needs to use MSSQL.

      How/Where do I specify that certain beans use one datasource while other beans should use another datasource?

      Thanks!

        • 1. Re: Using different datasources
          Sloan Seaman Newbie

          To answer my own question (for anyone who may need the answer):

          Take a copy of jbosscmp-jdbc.xml which you can find in /server/default/conf as standardjbosscmp-jdbc.xml and place the file (renamed to jbosscmp-jdbc.xml) in your META-INF dir.

          Modify the file according to your needs.

          When you deploy the app it will use the jbosscmp-jdbc.xml in your META-INF.

          You will still need to add realm information into your login-config.xml