8 Replies Latest reply on Aug 22, 2002 3:47 PM by nkm1

    JBoss 3- MS SQL Server 2000 connection problem

    vinodv

      Hi,

      I am using JBoss 3.0 and MS SQL Server 2000(Microsoft SQL Server 2000 Driver For JDBC.) as the database. I am having problems connecting to the database.


      Following are the details specfied in my XXX-service.xml


      MsSqlDbDS


      <config-property name="ConnectionURL" type="java.lang.String">
      jdbc:microsoft:sqlserver://localhost:1433;User=sa;DatabaseName=JBuggerDB;SelectMethod=cursor
      </config-property>
      <config-property name="DriverClass" type="java.lang.String">com.microsoft.jdbc.sqlserver.SQLServerDriver</config-property>
      <config-property name="UserName" type="java.lang.String">sa</config-property>
      <config-property name="Password" type="java.lang.String"></config-property>



      When I try to retrieve a connection from the data source I encounter the following exception

      18:37:28,903 ERROR [STDERR] org.jboss.util.NestedSQLException: Apparently wrong driver class specified for URL: class: com.microsoft.jdbc.sqlserver.SQLServerDriver, url:
      jdbc:microsoft:sqlserver://localhost:1433;User=sa;DatabaseName=JBuggerDB;SelectMethod=cursor
      ; - nested throwable: (javax.resource.ResourceException: Apparently wrong driver class specified for URL: class: com.microsoft.jdbc.sqlserver.SQLServerDriver, url
      jdbc:microsoft:sqlserver://localhost:1433;User=sa;DatabaseName=JBuggerDB;SelectMethod=cursor
      )
      18:37:28,923 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:106)

      Can some one help me out???