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

[tysmeister]

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

[tysmeister]

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