Thanks for the replies! I got it working with the
XADataSourceImpl and I also had to set SelectMethod=cursor to avoid the
Can't start a cloned connection while in manual transaction mode
error. For the record here's my working config:
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=SQLServerPool">
<attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="PoolName">SQLServerPool</attribute>
<attribute name="URL">jdbc:microsoft:sqlserver://sqltest1:1433;SelectMethod=cursor</attribute>
<attribute name="Properties">DatabaseName=testlog</attribute>
<attribute name="JDBCUser">rn_user</attribute>
<attribute name="Password">rn_user</attribute>
</mbean>
Thanks again!
JD
P.S. Yes, the MS site does say the Driver is for SQL Server 2000. I have
my small test bean working with SQL Server 7.0, but I may well run
into problems later and have to move to SQL Server 2000.
-----Original Message-----
From: Michael Schulz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 10:06 AM
To: JD Brennan; JBoss Users (E-mail)
Subject: RE: [JBoss-user] Configuring JBoss 2.4 with MS SQL Server?
You should check on the Microsoft web site, but I'm pretty sure that the Microsoft JDBC Driver only supports SQL Server 2000.
-Mike
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JD Brennan
Sent: Wednesday, March 13, 2002 7:06 PM
To: JBoss Users (E-mail)
Subject: [JBoss-user] Configuring JBoss 2.4 with MS SQL Server?
I'm trying to set up MS SQL Server 7.0 with JBoss 2.4.4
<mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">org.hsqldb.jdbcDriver,com.microsoft.jdbc.sqlserver.SQLServerDriver</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=SQLServerPool">
<attribute name="DataSourceClass">com.microsoft.jdbcx.sqlserver.SQLServerDataSource</attribute>
<attribute name="PoolName">SQLServerPool</attribute>
<attribute name="URL">jdbc:microsoft:sqlserver://sqltest1:1433</attribute>
<attribute name="Properties">DatabaseName=testlog</attribute>
<attribute name="JDBCUser">rn_user</attribute>
<attribute name="Password">rn_user</attribute>
</mbean>
Error:
[ERROR,ConfigurationService] Unexpected error
java.lang.NoClassDefFoundError: javax/sql/DataSource
Full error stack trace is below. This javax.sql.DataSource
is in the jboss/lib/jboss-jdbc_ext.jar file. I tried putting
that in JBOSS_CLASSPATH before starting jboss and copying it
the the jboss/lib/ext directory, but that didn't make any difference.
A search of the mail archive turned up a similar problem with
InstantDB where a null URL would cause this problem, but I don't
have a null URL.
Any ideas?
Thanks!
JD
Full error stack trace:
[ERROR,ConfigurationService] Unexpected error
java.lang.NoClassDefFoundError: javax/sql/DataSource
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:486)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:111)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:248)
at java.net.URLClassLoader.access$100(URLClassLoader.java:56)
at java.net.URLClassLoader$1.run(URLClassLoader.java:195)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:297)
at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:486)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:111)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:248)
at java.net.URLClassLoader.access$100(URLClassLoader.java:56)
at java.net.URLClassLoader$1.run(URLClassLoader.java:195)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:297)
at java.lang.ClassLoader.loadClass(ClassLoader.java:290)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:286)
at java.lang.ClassLoader.loadClass(ClassLoader.java:290)
at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:120)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:348)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:967)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.Main.<init>(Main.java:208)
at org.jboss.Main$1.run(Main.java:110)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:106)
--
