[jboss-dev-forums] [Deployers on JBoss (Deployers/JBoss)] - 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.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4165932#4165932

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4165932