CMP: Always Using DefaultDS not MySqlDS

[javaclimber]

I am trying to use MySQL as a DataSource for CMP. I have configured the DataSource and I am able to look up and use the DataSource from a Servlet with:

DataSource ds = (DataSource)jndiCntx.lookup("java:comp/env/MySqlDS");
or
DataSource ds = (DataSource) ic.lookup("java:/MySqlDS");

When I use CMP the DefaultDS is always used. The only addition I made for this DataSource was (jbosscmp-jdbc.xml):

<jbosscmp-jdbc>

java:/MySqlDS
<datasource-mapping>mySQL</datasource-mapping>
<preferred-relation-mapping>foreign-key</preferred-relation-mapping>


Are there any other changes I need to make? Is there any way to check in the JMX-Console to see what datasource a CMP is configured to use?

I am using JBoss-3.2.3.

Thanks
Kevin Nilson

[javaclimber]

Sorry the defaults and datasource tags are not showing up correctly

[darranl]

Is the 'jbosscmp-jdbc.xml' in the jar file in the correct location?

[javaclimber]

darranl,

Thanks for the help.

My ant build script had:





I left out the jbosscmp-jdbc.xml so it was not getting deployed in the jar. I will fix this and I assume it will fix my problem.

Thanks
Kevin