9 Replies Latest reply on Apr 19, 2002 10:32 PM by Craig Day

    SQL Server - Microsoft Driver

    Geoffrey Wiseman Newbie

      Has anyone made use of the new Microsoft SQL Server JDBC driver w/ JBoss? I gave it a shot, and had problems. Rather than work extensively to figure it out, considering I'm relatively new to JBoss, I thought I'd see if anyone else had luck.

      I put this in JBoss.jcml:

       <mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
       <attribute name="Drivers">
       org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,com.microsoft.jdbc.sqlserver.SQLServerDriver
       </attribute>
       </mbean>
      
       <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=dbVoicenet">
       <attribute name="DataSourceClass">com.microsoft.jdbcx.sqlserver.SQLServerDataSource</attribute>
       <attribute name="PoolName">dbVoicenet</attribute>
       <attribute name="Properties">ServerName=panthro;PortNumber=1433;DatabaseName=dbVoicenetDevGeoff</attribute>
       <attribute name="JDBCUser">voicenetUser</attribute>
       <attribute name="Password">xporbust</attribute>
       </mbean>
      


      And I got this response:
      java.lang.ClassCastException:
      com.microsoft.jdbcx.sqlserver.SQLServerDataSource
       at
      org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.jav
      a:345)
       at
      org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107
      )
       at java.lang.reflect.Method.invoke(Native Method)
       at
      com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
      28)
       at
      com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
      23)
       at
      org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Conf
      igurationService.java:836)
       at $Proxy0.start(Unknown Source)
       at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
       at java.lang.reflect.Method.invoke(Native Method)
       at
      com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
      28)
       at
      com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
      23)
       at org.jboss.Main.<init>(Main.java:210)
       at org.jboss.Main$1.run(Main.java:116)
       at java.security.AccessController.doPrivileged(Native Method)