SQL Server - Microsoft Driver
diathesis Oct 2, 2001 4:41 PMHas 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)