I have MySQL working properly in as the default datasource for JBOSS RC3, but I was trying to get an application to use a different database (MS SQL) in the CD application, to see what is needed to do it. Anyway, I have tried all sorts of different configs to get it working, but it uses the default configuration no matter what. What am I doing wrong?

Here are the configs for the CD app:

ejb-jar.xml section:
-------------------------------------------------------
<ejb-jar>
....
<resource-managers>
<resource-manager res-class="">
<res-name>MSSQLDS</res-name>
<res-jndi-name>java:/MSSQLDS</res-jndi-name>
</resource-manager>
</resource-managers>

<enterprise-beans>

...
<resource-ref>
<res-ref-name>java:/MSSQLDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
-------------------------------------------------------
jaws.xml section:


java:/MSSQLDS
<type-mapping>MS SQLSERVER</type-mapping>
...
-------------------------------------------------------
jboss.xml section:


...
<resource-managers>
<resource-manager res-class="org.jboss.ejb.deployment.JDBCResource">
<res-name>MSSQLDS</res-name>
<res-jndi-name>java:/MSSQLDS</res-jndi-name>
</resource-manager>
</resource-managers>

<enterprise-beans>
...

<ejb-name>CDBean</ejb-name>
<jndi-name>cd/CD</jndi-name>
<resource-ref>
<res-ref-name>java:/MSSQLDS</res-ref-name>
<resource-name>MSSQLDS</resource-name>
</resource-ref>

</enterprise-beans>
...

rodelor