2 Replies Latest reply on Jul 22, 2008 1:28 PM by szymanski

    JBOSS 5.0 + SQL SERVER 2005 = ClassNotFoundException: com.mi

    szymanski

      Hi friends,

      I'm trying to use JBOSS 5.0 with MS SQLSERVER 2005, but I'm getting the following error:

      [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jbo
      ss.resource.JBossResourceException: Failed to register driver for: com.microsoft.sqlserver.jdbc.SQLS
      erverDriver; - nested throwable: (java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQL
      ServerDriver.



      I put the lib driver in the server/default/lib folder and my datasource-ds.xml is like this

      <?xml version="1.0" encoding="UTF-8"?>
      <datasources>
       <local-tx-datasource>
       <jndi-name>MSSQLDS</jndi-name>
       <connection-url>
       jdbc:sqlserver://localhost;instanceName=SQL2005;portNumber=1433;databaseName=question;
       </connection-url>
       <driver-class>
       com.microsoft.sqlserver.jdbc.SQLServerDriver
       </driver-class>
       <user-name>xxx</user-name>
       <password>xxx</password>
       <metadata>
       <type-mapping>MS SQLSERVER</type-mapping>
       </metadata>
       </local-tx-datasource>
      </datasources>
      



      every time that I start the server, I get the error, what hell is going on...?
      Thanks to everyone.