RE: Please help with JDBC

[Todd Story]

Title: Please help with JDBC

Put jdbc2_0-stdext.jar in your %Tomcat%\lib directory and restart.  That jar contains the appropriate DataSource class.

-----Original Message-----
From: Luna, Kat [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 8:42 AM
To: [EMAIL PROTECTED]
Subject: Please help with JDBC

Hi all, I'm having a lot of difficulty understanding the way Struts handles JDBC.  I've got a MySQL database that I can access through JDBC from a standard Java class, so I know that my computer's configuration, classpath and drivers are all set properly, but as soon as I add the <datasource> to my struts-config.xml, I get the following error.  When I run the DatabaseTest.java class from the command prompt it has no problem accessing the database, but obviously Struts or Tomcat or one of the parsers is not finding javax/sql/DataSource.  Can anyone help me get this setup correct?

New org.apache.struts.util.GenericDataSource
java.lang.NoClassDefFoundError: javax/sql/DataSource
        at java.lang.ClassLoader.defineClass0(Native Method)
        at java.lang.ClassLoader.defineClass(ClassLoader.java:486)
        at org.apache.tomcat.loader.AdaptiveClassLoader12.doDefineClass(AdaptiveClassLoader12.java:9
3)
        at org.apache.tomcat.loader.AdaptiveClassLoader.loadClass(AdaptiveClassLoader.java:509)
        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.apache.struts.digester.ObjectCreateRule.begin(ObjectCreateRule.java:152)
        at org.apache.struts.digester.Digester.startElement(Digester.java:498)
        at org.xml.sax.helpers.XMLReaderAdapter.startElement(XMLReaderAdapter.java:329)
        at org.apache.xerces.parsers.SAXParser.startElement(SAXParser.java:1376)
        at org.apache.xerces.validators.common.XMLValidator.callStartElement(XMLValidator.java:1170)

        at org.apache.xerces.framework.XMLDocumentScanner.scanElement(XMLDocumentScanner.java:1862)
        at org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.dispatch(XMLDocumentScan
ner.java:1238)
        at org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:381)
        at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:952)
        at org.xml.sax.helpers.XMLReaderAdapter.parse(XMLReaderAdapter.java:223)
        at javax.xml.parsers.SAXParser.parse(SAXParser.java:345)
        at javax.xml.parsers.SAXParser.parse(SAXParser.java:143)
        at org.apache.struts.digester.Digester.parse(Digester.java:716)
        at org.apache.struts.action.ActionServlet.initMapping(ActionServlet.java:1301)
        at org.apache.struts.action.ActionServlet.init(ActionServlet.java:465)
        at javax.servlet.GenericServlet.init(GenericServlet.java:258)
        at org.apache.tomcat.core.ServletWrapper.doInit(ServletWrapper.java:317)
        at org.apache.tomcat.core.Handler.init(Handler.java:215)
        at org.apache.tomcat.core.ServletWrapper.init(ServletWrapper.java:296)
        at org.apache.tomcat.context.LoadOnStartupInterceptor.contextInit(LoadOnStartupInterceptor.j
ava:130)
        at org.apache.tomcat.core.ContextManager.initContext(ContextManager.java:491)
        at org.apache.tomcat.core.ContextManager.init(ContextManager.java:453)
        at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java:195)
        at org.apache.tomcat.startup.Tomcat.main(Tomcat.java:235)
Begin event threw exception
java.lang.ClassNotFoundException: org/apache/struts/util/GenericDataSource
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:120)
        at org.apache.struts.digester.ObjectCreateRule.begin(ObjectCreateRule.java:152)
        at org.apache.struts.digester.Digester.startElement(Digester.java:498)
        at org.xml.sax.helpers.XMLReaderAdapter.startElement(XMLReaderAdapter.java:329)
        at org.apache.xerces.parsers.SAXParser.startElement(SAXParser.java:1376)
        at org.apache.xerces.validators.common.XMLValidator.callStartElement(XMLValidator.java:1170)

        at org.apache.xerces.framework.XMLDocumentScanner.scanElement(XMLDocumentScanner.java:1862)
        at org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.dispatch(XMLDocumentScan
ner.java:1238)
        at org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:381)
        at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:952)
        at org.xml.sax.helpers.XMLReaderAdapter.parse(XMLReaderAdapter.java:223)
        at javax.xml.parsers.SAXParser.parse(SAXParser.java:345)
        at javax.xml.parsers.SAXParser.parse(SAXParser.java:143)
        at org.apache.struts.digester.Digester.parse(Digester.java:716)
        at org.apache.struts.action.ActionServlet.initMapping(ActionServlet.java:1301)
        at org.apache.struts.action.ActionServlet.init(ActionServlet.java:465)
        at javax.servlet.GenericServlet.init(GenericServlet.java:258)
        at org.apache.tomcat.core.ServletWrapper.doInit(ServletWrapper.java:317)
        at org.apache.tomcat.core.Handler.init(Handler.java:215)
        at org.apache.tomcat.core.ServletWrapper.init(ServletWrapper.java:296)
        at org.apache.tomcat.context.LoadOnStartupInterceptor.contextInit(LoadOnStartupInterceptor.j
ava:130)
        at org.apache.tomcat.core.ContextManager.initContext(ContextManager.java:491)
        at org.apache.tomcat.core.ContextManager.init(ContextManager.java:453)
        at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java:195)
        at org.apache.tomcat.startup.Tomcat.main(Tomcat.java:235)
cannot load servlet name: action: Parsing error processing resource path /WEB-INF/struts-config.xml

thanks a million!

Kat Luna
[EMAIL PROTECTED]