[jboss-user] [JNDI and Naming] - JBOSS 4.2.2 and MS SQL 2005

[mauri11760]

Hi there,
I just installed JBOSS 4.2.2 and I want to use MS SQL 2005. So this is what I did:
1. Deleted JBOSS_HOME/server/default/deploy/hsqldb-ds.xml
2. Copied JBOSS_HOME/docs/examples/jca/mssql-ds.xml to JBOSS_HOME/server/default/deploy.
3. In the new copy of mssql-ds.xml, I edit the connection-url, user-name and password elements to match my local SQL db instance.
4. Changed the value of the jndi-name element from MSSQLDS to DefaultDS
5. Deleted the file JBOSS_HOME/server/default/deploy/jms/hsqldb-jdbc2-service.xml.
6. Copied JBOSS_HOME/docs/examples/jms/mssql-jdbc2-service.xml into the folder JBOSS_HOME/server/default/deploy/jms
7. In the new copy of mssql-jdbc2-service.xml, I replaced  the string MSSQLDS with DefaultDS
8. I copied the MSSQL JDBC driver sqljdbc.jar to JBOSS_HOME/server/default/lib.

When I start JBOSS I get the following error:
2009-09-03 16:59:34,609 WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
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://192.168.0.1:1433;DatabaseName=systinetdb)
	at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)
	at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:577)
	at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:262)
	at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:500)
	at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)...

Do you have any suggestion?

Thanks
Maurizio


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

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