Jboss & SQL server 2008

[Faraz Ali]

Hi Ranchers,

I am unable to deploy my beans on jboss. The database i am using is SQL server 2008. Driver file is sqljdbc.jar, driver class is com.microsoft.sqlserver.jdbc.SQLServerDriver, the url is jdbc:microsoft:sqlserver://myMachine/mytestdb. The persistence.xml file is below:

 
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
	<persistence-unit name="AppBeans">
		<jta-data-source>java:/MSSQLDS</jta-data-source>
		<properties>
			<property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect"/>			
			<property name="hibernate.show_sql" value="true"/>
		</properties>
	</persistence-unit>
</persistence>

Where to put the driver jar file. And below is the exception i am getting:

org.jboss.resource.JBossResourceException: Could not create connection; - 
nested throwable: (org.jboss.resource.JBossResourceException: 
Apparently wrong driver class specified for URL: class: com.microsoft.sqlserver.jdbc.SQLServerDriver,
 url: jdbc:microsoft:sqlserver://myMachine/mytestdb)
	at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)
..
..
Caused by: javax.resource.ResourceException: Unable to get managed connection for MSSQLDS
	at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)
	at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
..
..
Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException:
 Apparently wrong driver class specified for URL:
 class: com.microsoft.sqlserver.jdbc.SQLServerDriver, 
url: jdbc:microsoft:sqlserver://myMachine/mytestdb)
	at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)

Please help to fix above issues.


Thanks,

[Jaikiran Pai]

Faraz Ali wrote:Hi Ranchers,

the url is jdbc:microsoft:sqlserver://myMachine/mytestdb.

As per this documentation, you are using a wrong url pattern.