Is com.microsoft.jdbcx.sqlserver.SQLServerDataSource really an
XADataSource?  if not, you should use XADataSourceImpl and specify the
driver by the url for the db.

david jencks

On 2002.03.13 20:05:38 -0500 JD Brennan wrote:
> 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.SQLServerD
> river</attribute>
>   </mbean>
> 
>   <mbean code="org.jboss.jdbc.XADataSourceLoader"
> name="DefaultDomain:service=XADataSource,name=SQLServerPool">
>     <attribute
> name="DataSourceClass">com.microsoft.jdbcx.sqlserver.SQLServerDataSource</at
> tribute>
>     <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(Configurati
> onService.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)
> --
> 
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
> <HTML>
> <HEAD>
> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
> <TITLE>Configuring JBoss 2.4 with MS SQL Server?</TITLE>
> </HEAD>
> <BODY>
> 
> <P><FONT SIZE=2>I'm trying to set up MS SQL Server 7.0 with JBoss
> 2.4.4</FONT>
> </P>
> 
> <P><FONT SIZE=2>&nbsp; &lt;mbean code=&quot;org.jboss.jdbc.JdbcProvider&quot;
> name=&quot;DefaultDomain:service=JdbcProvider&quot;&gt;</FONT>
> <BR><FONT SIZE=2>&nbsp;&nbsp;&nbsp;&nbsp; &lt;attribute
> 
>name=&quot;Drivers&quot;&gt;org.hsqldb.jdbcDriver,com.microsoft.jdbc.sqlserver.SQLServerDriver&lt;/attribute&gt;</FONT>
> <BR><FONT SIZE=2>&nbsp; &lt;/mbean&gt;</FONT>
> </P>
> 
> <P><FONT SIZE=2>&nbsp; &lt;mbean code=&quot;org.jboss.jdbc.XADataSourceLoader&quot;
> name=&quot;DefaultDomain:service=XADataSource,name=SQLServerPool&quot;&gt;</FONT>
> <BR><FONT SIZE=2>&nbsp;&nbsp;&nbsp; &lt;attribute
> 
>name=&quot;DataSourceClass&quot;&gt;com.microsoft.jdbcx.sqlserver.SQLServerDataSource&lt;/attribute&gt;</FONT>
> <BR><FONT SIZE=2>&nbsp;&nbsp;&nbsp; &lt;attribute
> name=&quot;PoolName&quot;&gt;SQLServerPool&lt;/attribute&gt;</FONT>
> <BR><FONT SIZE=2>&nbsp;&nbsp;&nbsp; &lt;attribute
> 
>name=&quot;URL&quot;&gt;jdbc:microsoft:sqlserver://sqltest1:1433&lt;/attribute&gt;</FONT>
> <BR><FONT SIZE=2>&nbsp;&nbsp;&nbsp; &lt;attribute
> name=&quot;Properties&quot;&gt;DatabaseName=testlog&lt;/attribute&gt;</FONT>
> <BR><FONT SIZE=2>&nbsp;&nbsp;&nbsp; &lt;attribute
> name=&quot;JDBCUser&quot;&gt;rn_user&lt;/attribute&gt;</FONT>
> <BR><FONT SIZE=2>&nbsp;&nbsp;&nbsp; &lt;attribute
> name=&quot;Password&quot;&gt;rn_user&lt;/attribute&gt;</FONT>
> <BR><FONT SIZE=2>&nbsp; &lt;/mbean&gt;</FONT>
> </P>
> 
> <P><FONT SIZE=2>Error:</FONT>
> </P>
> 
> <P><FONT SIZE=2>[ERROR,ConfigurationService] Unexpected error</FONT>
> <BR><FONT SIZE=2>java.lang.NoClassDefFoundError:
> javax/sql/DataSource</FONT>
> </P>
> 
> <P><FONT SIZE=2>Full error stack trace is below.&nbsp; This
> javax.sql.DataSource</FONT>
> <BR><FONT SIZE=2>is in the jboss/lib/jboss-jdbc_ext.jar file.&nbsp; I
> tried putting</FONT>
> <BR><FONT SIZE=2>that in JBOSS_CLASSPATH before starting jboss and
> copying it</FONT>
> <BR><FONT SIZE=2>the the jboss/lib/ext directory, but that didn't make
> any difference.</FONT>
> <BR><FONT SIZE=2>A search of the mail archive turned up a similar problem
> with</FONT>
> <BR><FONT SIZE=2>InstantDB where a null URL would cause this problem, but
> I don't</FONT>
> <BR><FONT SIZE=2>have a null URL.</FONT>
> </P>
> 
> <P><FONT SIZE=2>Any ideas?</FONT>
> <BR><FONT SIZE=2>Thanks!</FONT>
> <BR><FONT SIZE=2>JD</FONT>
> </P>
> 
> <P><FONT SIZE=2>Full error stack trace:</FONT>
> </P>
> 
> <P><FONT SIZE=2>[ERROR,ConfigurationService] Unexpected error</FONT>
> <BR><FONT SIZE=2>java.lang.NoClassDefFoundError:
> javax/sql/DataSource</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.ClassLoader.defineClass0(Native Method)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.ClassLoader.defineClass(ClassLoader.java:486)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.security.SecureClassLoader.defineClass(SecureClassLoader.java:111)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.net.URLClassLoader.defineClass(URLClassLoader.java:248)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.net.URLClassLoader.access$100(URLClassLoader.java:56)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.net.URLClassLoader$1.run(URLClassLoader.java:195)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.security.AccessController.doPrivileged(Native Method)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.net.URLClassLoader.findClass(URLClassLoader.java:188)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.ClassLoader.loadClass(ClassLoader.java:297)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.ClassLoader.loadClass(ClassLoader.java:253)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.ClassLoader.defineClass0(Native Method)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.ClassLoader.defineClass(ClassLoader.java:486)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.security.SecureClassLoader.defineClass(SecureClassLoader.java:111)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.net.URLClassLoader.defineClass(URLClassLoader.java:248)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.net.URLClassLoader.access$100(URLClassLoader.java:56)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.net.URLClassLoader$1.run(URLClassLoader.java:195)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.security.AccessController.doPrivileged(Native Method)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.net.URLClassLoader.findClass(URLClassLoader.java:188)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.ClassLoader.loadClass(ClassLoader.java:297)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.ClassLoader.loadClass(ClassLoader.java:290)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:286)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.ClassLoader.loadClass(ClassLoader.java:290)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.ClassLoader.loadClass(ClassLoader.java:253)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.Class.forName0(Native Method)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.Class.forName(Class.java:120)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:348)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.reflect.Method.invoke(Native Method)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> 
>org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:967)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> $Proxy0.start(Unknown Source)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> org.jboss.util.ServiceControl.start(ServiceControl.java:79)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.lang.reflect.Method.invoke(Native Method)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> org.jboss.Main.&lt;init&gt;(Main.java:208)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> org.jboss.Main$1.run(Main.java:110)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> java.security.AccessController.doPrivileged(Native Method)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>at
> org.jboss.Main.main(Main.java:106)</FONT>
> <BR><FONT SIZE=2>--</FONT>
> </P>
> 
> </BODY>
> </HTML>
> 

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to