0 Replies Latest reply on Jun 30, 2002 8:29 PM by Robert de Lorimier

    Datasource by application

    Robert de Lorimier Newbie

      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