2 Replies Latest reply on Oct 15, 2003 2:32 PM by nithyaswam

    Ms Access Datasource mapping error.

    nithyaswam Newbie

      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

        • 1. Re: Ms Access Datasource mapping error.
          Jon Barnett Master

          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.

          • 2. Re: Ms Access Datasource mapping error.
            nithyaswam Newbie

            Hi

            Thanks a lot for your advice. It worked!
            Nithya