4 Replies Latest reply on Jun 11, 2004 3:15 AM by Alexandre Touret

    CMP EJB cant bind MS SQL Datasource

    Alexandre Touret Newbie

      Hi all,
      When my CMP EJB communicates with MS SQL Server 2000, they seem to use the default datasource which is configured for HSQLDB instead of the MS SQL datasource.

      On the other hand, when my sessions beans communicates with this datasource, Everything works fine....

      I m working with :


      JBOSS 3.2.3
      J2SE 1.4.2-04
      MS SQL SERVER 2000
      JDBC DRIVER: Microsoft SQL Server 2000 Driver for JDBC SP2 Version 2.2.0037 ( August 2003 )


      "My mssql.xml" wrote:

      <datasources>
      <local-tx-datasource>
      <jndi-name>DirectoryDS</jndi-name>
      <connection-url>jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=directory</connection-url>
      <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
      <user-name>sa</user-name>
      <password></password>
      </local-tx-datasource>
      </datasources>


      "My jbosscmp-jdbc.xml " wrote:
      <jbosscmp-jdbc>
      <defaults>
      <datasource>java:/DirectoryDS</datasource>
      <datasource-mapping>MS SQLSERVER2000</datasource-mapping>
      </defaults>

      <enterprise-beans>

      <!--
      To add beans that you have deployment descriptor info for, add
      a file to your XDoclet merge directory called jbosscmp-jdbc-beans.xml
      that contains the <entity></entity> markup for those beans.
      -->
      [...]


      Thanks for helping

      Alexandre Touret