Client has much data in a Microsoft Access database, as well as proprietary application to use that database. However they also wish to use JBoss to provide Java access to that database through CMP EJB. I have mapped EJB definitions to the tables and relationships, however, I do not know how to tell JBoss to use the Access database as the datasource.
I see that JBoss comes in the docs/examples/jca directory with an "msaccess-service.xml". Does anyone have helpful experience in using this service as datasource for CMP?
Many thanks for advice!