10 Replies Latest reply on Feb 28, 2006 8:50 AM by Holger Johanndeiter

    Error: can't find data source: java:/MSSQLDS

    Holger Johanndeiter Newbie

      Hello,
      I'm trying to run JBoss 4.03SP1 together with MS SQLSERVER 2000 for a company page using JSP.
      But I'm stuck on configuring the database.

      I donwloaded and installed the JDBC drivers for MSSQL2000.

      my mssql-ds.xml looks as follows:

      <datasources>
       <local-tx-datasource>
       <jndi-name>MSSQLSERVER2000</jndi-name>
       <connection-url>jdbc:microsoft:sqlserver://w2k-praktikant\webfactory;SelectMethod=cursor;DatabaseName=KVN_Allershausen</connection-url>
       <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
       <user-name>sa</user-name>
       <password>webfactory</password>
       <!-- sql to call when connection is created
       <new-connection-sql>some arbitrary sql</new-connection-sql>
       -->
      
       <!-- sql to call on an existing pooled connection when it is obtained from pool
       <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
       -->
       <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
       <metadata>
       <type-mapping>MSSQLSERVER2000</type-mapping>
       </metadata>
       </local-tx-datasource>
      
      </datasources>


      I changed the standardjbosscmp-jdbc.xml maybe that isnt such a good idea?

      in it i changed:
       <datasource>MSSQLDS</datasource>
       <datasource-mapping>MSSQLSERVER2000</datasource-mapping>
      


      nothing else changed.