error creating sqlserver 7 connection pool in jboss2.4/tomca
mokeefe Apr 15, 2002 10:54 PMI'm using the sun jdbc_odbc bridge to connect to a ms sqlserver 7.0 database on Windows 2000.
here is the entry in the jboss.jcml file:
org.hsqldb.jdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver
<!-- Hypersonic Database, DefaultDS stuff.... -->
org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl
SQLServerPool
jdbc:odbc:j2ee
mokeefe
93comet
Next, the server.log entries for the mbeans:
The sun driver loads ok on startup:
[21:37:59,841,JdbcProvider] Loaded JDBC-driver:sun.jdbc.odbc.JdbcOdbcDriver
The SQLServerPool entry is being initialized:
[21:37:59,881,SQLServerPool] Initializing
[21:37:59,881,SQLServerPool] Initialized
The JDBC provider and Hypersonic stuff loads ok:
[21:38:01,483,JdbcProvider] Starting
[21:38:01,483,JdbcProvider] Started
[21:38:01,493,HypersonicDatabase] Starting
[21:38:02,024,Default] Server 1.6 is running
[21:38:02,034,Default] Press [Ctrl]+[C] to abort
[21:38:02,034,HypersonicDatabase] Database started
[21:38:02,044,HypersonicDatabase] Started
[21:38:02,054,DefaultDS] Starting
[21:38:02,285,DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS
[21:38:02,595,DefaultDS] Started
Then the error when the SQLServerPool service is starting:
[21:38:02,605,SQLServerPool] Starting
[21:38:02,645,ConfigurationService] Unexpected error
java.lang.NoClassDefFoundError: javax/sql/XADataSource
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:493)
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:299)
at java.lang.ClassLoader.loadClass(ClassLoader.java:292)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:286)
at java.lang.ClassLoader.loadClass(ClassLoader.java:292)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
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.(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)
It appears JBOSS cannot find a class but I've tried adding the numerous jar files (including the j2ee.jar) file to the jboss/lib/ext folder, and nothing is working. Any help is appreciated.