Ms Access Datasource mapping error.

[nithyaswam]

Hi:

I am using Eclipse, Lomboz and JBOSS while working with my EJBS. I used the msaccess-ds.xml and put it into my deploy directory. I was able to successfully use a session bean to get information from the MS Access database.
A week later, i am learning to use CMP entity beans. I get the following error while deploying the bean.

"org.jboss.deployment.DeploymentException: Error in jbosscmp-jdbc.xml : datasource-mapping MSAccess not found"

my msaccess-ds.xml file is as follows

<local-tx-datasource>
<jndi-name>MSAccessmemorialDS</jndi-name>
<!-- format of URL is "jdbc:odbc:DSNNAME" -->
<connection-url>jdbc:odbc:Memorial</connection-url>
<driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class>
<user-name></user-name>

</local-tx-datasource>



CAN ANyone guide me on what is going on in this. why is this error happening. It never happened for my session beans.
I would be grateful if someone can have the patience to explain this error
Thanks in advance!
Nithya

[jonlee]

Your DataSource Mapping, MSAccess must match a type-mapping schema with that name - depending on the CMP spec you are following (1.1 or 2.0), you would need to modify either standardjaws.xml or standardjbosscmp-jdbc.xml respectively. Since a mapping does not exist for Access you should probably copy the SQL Server type-mapping, give it the name MSAccess or whatever you want to call it, and trial it. From reports, that should work for the most part but you may need to modify the mapping if you get any errors.

Entity beans require a mapping table since they must generate dynamic SQL to put and get data from the database. The mapping information helps the entity bean get the SQL and data types correct for the processes.

[nithyaswam]

Hi

Thanks a lot for your advice. It worked!
Nithya