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,
If memory serves me correctly, the ability to have two cmp entities mapped to two different datasource was not added until JBoss 2.4.x.