1 Reply Latest reply on Sep 6, 2003 6:50 AM by Andrew Tyson

    CMP Entity EJB <datasource-mapping> for Ingres ??

    Andrew Tyson Newbie

      Hi,

      I am trying to deploy a CMP Entity EJB into a JBoss 3.0.3 container, running against an Ingres 2.5 RDBMS, but continuously get the following deployment error;

      15:17:53,830 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=Contacts,service=EJB
      org.jboss.deployment.DeploymentException: Error in jbosscmp-jdbc.xml : datasource-mapping cimPool not found


      I have created a $JBOSS_HOME/server/default/deploy/ingres-service.xml datasource that works fine (as evidenced by the fact that I can get pooled connections to the DBMS fine, and container based authentication and authorisation works fine). The problem seems to centre around the (to me) mysterious <datasource-mapping> element in the jbosscmp-jdbc.xml DD that is deployed wiith my CMP 2.0 entity EJBs. Judging by the default Hypersonic example this appears to be a free text description, however I cannot figure out what I need to put in here to get the Entity EJBs deployed against my Ingres Datasource.


      Thanks and regards,
      Andrew

        • 1. Re: CMP Entity EJB <datasource-mapping> for Ingres ??
          Andrew Tyson Newbie

          Ok - having bought and downloaded the JBoss CMP 2.0 doco I finally have been able to track down that the type mappings need to be performed on an RDBMS basis in $JBOSS_HOME/server/default/conf/standardjbosscmp-jdbc.xml config file. There is no mapping for Ingres in 3.0.x but the 3.2.x version appears to have a mapping (albeit no mention is made of which version).

          Can anyone attest to having successfully used this mapping, and if so which version(s) of the RDBMS?

          Thanks and regards,
          Andrew