1 Reply Latest reply on Jan 29, 2002 1:19 PM by Dain Sundstrom

    Using multiple datastores with CMP EJBs

    TBuchan Newbie

      I am trying to build an application with CMP EJBs and two databases, with JBoss-2.2.2_Tomcat-3.2.2. The databases are mySQL and MS Access. In each of these databases I have a table called "employees" and each of the tables is represented by a separate CMP entity bean.

      The MySQL EJB works fine and I can use it to return all the records in the table. However I am having difficulties with the MS Access EJB. The system seems to deploy correctly, but when the method is called to return all records, I get the data from the mySQL database table instead of the MS Access data.

      I am using Sun's JDBC/ODBC standard driver and I have updated the references in the jboss.jcml file (and added another mbean definition). I also added another datasource and type mapping to my jaws.xml.

      Can anyone help me with this?

      I think the problem is with referencing the MS Access database correctly and possibly not overriding the default settings.

      Any help or pointers in the right direction would be appreciated,