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.jboss.resource.JBossResourceException: Failed to register driver for: com.microsoft.sqlserver.jdbc.SQLServerDriver; - nested throwable: (java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver.
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.
