Re: [JBoss-user] Configuring JBoss 2.4 with MS SQL Server?

Dmitri Colebatch Thu, 14 Mar 2002 13:31:05 -0800

Title: Configuring JBoss 2.4 with MS SQL Server?

I've had it working (not with JBoss) with SQL server 6.5 and 7 as well.

cheers

dim

----- Original Message -----

From: Michael Schulz

To: JD Brennan ; JBoss Users (E-mail)

Sent: Friday, March 15, 2002 5:05 AM

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)
--

Re: [JBoss-user] Configuring JBoss 2.4 with MS SQL Server?

Reply via email to