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

      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:

       <!-- 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) -->

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

      in it i changed:

      nothing else changed.