[jboss-user] [JNDI/Naming/Network] - MS SQL datasource error

[vitechinc2008]

Hi.  

I am new add JBOSS, got Oracle datasource to work, Now I need to connect to SQL 2005 but I am getting the following error:
Datasource config


  <local-tx-datasource>
    <jndi-name>basic_ds</jndi-name>
    <use-java-context>false</use-java-context>
    <connection-url>jdbc:microsoft:sqlserver://172.24.42.102:1433;DatabaseName=V3Test</connection-url>
    <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
    <user-name>password</user-name>
    password
    
      
         <type-mapping>MS SQLSERVER2000</type-mapping>
      
  </local-tx-datasource>



Error

15:30:21,455 INFO  [[/EQUITRAK]] Initializing Spring root WebApplicationContext
15:31:16,754 WARN  [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://172.24.42.102:1433;DatabaseName=V3Test)
        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:190)
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:619)
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:264)
        at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:575)
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)
        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:330)
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
        at org.springframework.orm.hibernate.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:77)
        at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:73)
        at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1156)
        at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:790)
        at org.springframework.orm.hibernate.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:540)
        at org.springframework.orm.hibernate.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:474)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1202)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1172)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:428)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:365)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$ConstructorResolverAdapter.findAutowireCandidates(AbstractAutowireCapableBeanFactory.java:1318)


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

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