RE: Installing mysql JDBC Driver

Gustav Lidén Thu, 29 Aug 2002 05:52:29 -0700

Hi,

I've been following this thread as I am sitting with the exact same problem. However I think I just got a bit further by unzipping the jar and putting it in the WEB-INF/classes directory. Thanks Jeremy! Tomcat now starts without trouble, but I get a Cocoon error page when requesting any html page (also ones that don't use mysql as a data source).

My cocoon.xconf contains:

    <jdbc name="mysql">
        <pool-controller max="10" min="5"/>
        <dburl>jdbc:mysql://localhost/web</dburl>
        <user>guslid</user>
        <password>guslid</password>
     </jdbc>

And the following works command-line-wise: mysql -uguslid -pguslid web

- so it shouldn't be a privilege thing?

The call stack is below, otherwise I can't see to much useful info in the logs.

Anyone see what's wrong?

/Gustav

javax.servlet.ServletException: Servlet.init() for servlet Cocoon2 threw exception
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:946)
	at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:655)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
	at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
	at java.lang.Thread.run(Thread.java:536)

root cause

java.lang.ClassFormatError: com/mysql/jdbc/Driver (Illegal constant pool type)
	at java.lang.ClassLoader.defineClass0(Native Method)
	at java.lang.ClassLoader.defineClass(ClassLoader.java:502)
	at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123)
	at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1643)
	at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:937)
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1372)
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1254)
	at org.apache.cocoon.util.ClassUtils.loadClass(ClassUtils.java:88)
	at org.apache.cocoon.servlet.CocoonServlet.forceLoad(CocoonServlet.java:842)
	at org.apache.cocoon.servlet.CocoonServlet.createCocoon(CocoonServlet.java:1219)
	at org.apache.cocoon.servlet.CocoonServlet.init(CocoonServlet.java:435)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:918)
	at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:655)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
	at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
	at java.lang.Thread.run(Thread.java:536)

-----Original Message-----
From: Jeremy Aston [mailto:[EMAIL PROTECTED]]
Sent: den 29 augusti 2002 13:15
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Installing mysql JDBC Driver

Oh yeah,
I forgot you might want to try extracting the jar into WEB-INF classes to see if that makes a difference. If that works I don't know what it should be able to get the class from classes and not inside the JAR...
jez
Jeremy Aston <[EMAIL PROTECTED]> wrote:

Hi Jessica,
Looks OK and you should be able to run the hsqldb driver as well. I have had no problems with mySQL on 2.0.3 and JDK 1.4 so you could try that. You could also comment out all the other driver references and the other pools to check there are no conflicts. I'm not sure that any of this is strictly necessary however. From the log messages it seems that the classloader is attempting to find the class but cannot. This would typically be because the package name is incorrect or the class is not there. The package name for that version of the JAR should be fine. Have you opened the jar in something like WINRAR or WINZIP? If not do so to check the file is not corrupt or otherwise wrong. You should be able to navigate the folder org/gjt/mm/mysql where Driver.class should exist.

HTH a little more.

Jez

Jessica Niewint <[EMAIL PROTECTED]> wrote:

If there are no config problems then post your web.xml and cocoon.xconf
extracts and I'll have a look. the jar should be fine in WEB-INF/lib.
I got exactly all this. The only point is that there a still the standard
driver in my installation.

my web.xml

load-class

org.hsqldb.jdbcDriver

org.gjt.mm.mysql.Driver

my cocoon.xconf:

jdbc:hsqldb:hsql://localhost:9002
sa

jdbc:mysql://localhost/test
root

Could there be another problem ?

At 16.37 28/08/2002 +0100, you wrote:

>Hi Jessica,
>
>You should have something like this in web.xml
>
>
> load-class
>
> org.gjt.mm.mysql.Driver
>
>
>
>and something like this in cocoon.xconf
>
>
>
>
> jdbc:mysql://127.0.0.1/databasename
> root
>
>
>
>
>If there are no config problems then post your web.xml and cocoon.xconf
>extracts and I'll have a look. the jar should be fine in WEB-INF/lib.
>
>Jez
>
>
>

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting.

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Get a bigger mailbox -- choose a size that fits your needs.

Get a bigger mailbox -- choose a size that fits your needs.

RE: Installing mysql JDBC Driver

Reply via email to