3 Replies Latest reply on Jun 30, 2004 8:44 PM by javaclimber

    CMP: Always Using DefaultDS not MySqlDS

    javaclimber Newbie

      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