0 Replies Latest reply on Apr 16, 2002 10:10 PM by Michael OKeefe

    error creating sqlserver 7 connection pool in jboss2.4/tomca

    Michael OKeefe Newbie

      I'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:datasource
      username
      password


      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.