CMP with MS Access

[bibo]

Hello,

i want to use jboss-3.2.1 with a MS Access Database. Everything works fine with Bean Managed Entity Beans but now i want to try it with Container Managed Entity Beans.

I configurated jbosscmp-jdbc.xml like that:

...
java:/MSAccessDS
<datasource-mapping>MS Access</datasource-mapping>
...

and xdoclet.xml as follows:

...
datasource="java:/MSAccessDS"
datasourcemapping="MS Access"
preferredrelationmapping="foreign-key"
...


know the following error occurs when i start the jboss server:

...
15:21:24,593 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
Cause: Incomplete Deployment listing:
Packages waiting for a deployer:

Incompletely deployed packages:

MBeans waiting for classes:

MBeans waiting for other MBeans:
[ObjectName: jboss.j2ee:jndiName=StaffBean,service=EJB
state: FAILED
I Depend On:
Depends On Me: org.jboss.deployment.DeploymentException: Error in jbosscmp-jdbc.xml : datasource-mapping MS Access not found, ObjectName: jboss.j2ee:jndiName=CostcenterBean,service=EJB
state: FAILED
I Depend On:
Depends On Me: org.jboss.deployment.DeploymentException: Error in jbosscmp-jdbc.xml : datasource-mapping MS Access not found]
...

I'm a student and beginner in using jboss. Does anyone know what the problem is?

[aloubyansky]

Default datasource-mapping are defined in standardjbosscmp-jdbc.xml. There is not one for Access. Either use an existing (non-Access) one or define your own.

[mprk]

Use the SQL Server data mapping (i.e. MS SQLSERVER2000).