You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Richard Thomas <ri...@thomasweb.org> on 2001/01/24 23:43:23 UTC

Cocoon and mySQL

I think I have everything configured correctly, based on the error message,
is there a cocoon related item I am missing?  Thanks.

Error message:

java.lang.RuntimeException: Error opening connection to dburl: jdbc:mysql://localhost:3306/statements
	at java.lang.Throwable.<init>(Throwable.java:96)
	at java.lang.Exception.<init>(Exception.java:44)
	at java.lang.RuntimeException.<init>(RuntimeException.java:49)
	at _opt._tomcat._webapps._cocoon._samples._sql._esql2.populateDocument(_esql2.java:162)
	at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97)
	at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:524)
	at org.apache.cocoon.Engine.handle(Engine.java:383)
	at org.apache.cocoon.Cocoon.service(Cocoon.java:183)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
	at org.apache.tomcat.core.Handler.service(Handler.java:286)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
	at java.lang.Thread.run(Thread.java:498)

Configuration:

...from xml file:
<esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
<esql:dburl>jdbc:mysql://localhost:3306/statements</esql:dburl>

Tomcat Web Server/3.2.1 (JSP 1.1; Servlet 2.2; Java 1.3.0; Linux 2.2.16-22 x86; java.vendor=IBM Corporation); Cocoon 1.8.1; mySQL 3.23.30-gamma; mm jdbc driver 1.2c.

RE: Cocoon and mySQL

Posted by Mauro Canal <mc...@connext.ch>.
the mm JDBC driver 1.2c is nearly one year old.

You should update your JDBC driver to the newest
2.0 stable version: mm.mysql-2.0.3-src.jar

to get from http://mmmysql.sourceforge.net/
Mauro Canal


-----Original Message-----
From: Richard Thomas [mailto:rich@thomasweb.org]
Sent: Thursday, January 25, 2001 2:49 AM
To: cocoon-users@xml.apache.org
Subject: Re: Cocoon and mySQL



  Yes it is,
    ----- Original Message -----
    From: Berin Loritsch
    To: cocoon-users@xml.apache.org
    Sent: Wednesday, January 24, 2001 5:37 PM
    Subject: Re: Cocoon and mySQL


    Is the driver in Cocoon's ClasPath?
      ----- Original Message -----
      From: Richard Thomas
      To: cocoon-users@xml.apache.org
      Sent: Wednesday, January 24, 2001 5:43 PM
      Subject: Cocoon and mySQL


      I think I have everything configured correctly, based on the error
message,
      is there a cocoon related item I am missing?  Thanks.

      Error message:

      java.lang.RuntimeException: Error opening connection to dburl:
jdbc:mysql://localhost:3306/statements
      at java.lang.Throwable.<init>(Throwable.java:96)
      at java.lang.Exception.<init>(Exception.java:44)
      at java.lang.RuntimeException.<init>(RuntimeException.java:49)
      at
_opt._tomcat._webapps._cocoon._samples._sql._esql2.populateDocument(_esql2.j
ava:162)
      at
org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97)
      at
org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:524)
      at org.apache.cocoon.Engine.handle(Engine.java:383)
      at org.apache.cocoon.Cocoon.service(Cocoon.java:183)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
      at org.apache.tomcat.core.Handler.service(Handler.java:286)
      at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
      at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
7)
      at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
      at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
(Ajp12ConnectionHandler.java:166)
      at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
      at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
      at java.lang.Thread.run(Thread.java:498)

      Configuration:

      ...from xml file:
      <esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
      <esql:dburl>jdbc:mysql://localhost:3306/statements</esql:dburl>

      Tomcat Web Server/3.2.1 (JSP 1.1; Servlet 2.2; Java 1.3.0; Linux
2.2.16-22 x86; java.vendor=IBM Corporation); Cocoon 1.8.1; mySQL
3.23.30-gamma; mm jdbc driver 1.2c.

Re: Cocoon and mySQL

Posted by Richard Thomas <ri...@thomasweb.org>.
Yes it is,
  ----- Original Message ----- 
  From: Berin Loritsch 
  To: cocoon-users@xml.apache.org 
  Sent: Wednesday, January 24, 2001 5:37 PM
  Subject: Re: Cocoon and mySQL


  Is the driver in Cocoon's ClasPath?
    ----- Original Message ----- 
    From: Richard Thomas 
    To: cocoon-users@xml.apache.org 
    Sent: Wednesday, January 24, 2001 5:43 PM
    Subject: Cocoon and mySQL


    I think I have everything configured correctly, based on the error message,
    is there a cocoon related item I am missing?  Thanks.

    Error message:

    java.lang.RuntimeException: Error opening connection to dburl: jdbc:mysql://localhost:3306/statements
    at java.lang.Throwable.<init>(Throwable.java:96)
    at java.lang.Exception.<init>(Exception.java:44)
    at java.lang.RuntimeException.<init>(RuntimeException.java:49)
    at _opt._tomcat._webapps._cocoon._samples._sql._esql2.populateDocument(_esql2.java:162)
    at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97)
    at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:524)
    at org.apache.cocoon.Engine.handle(Engine.java:383)
    at org.apache.cocoon.Cocoon.service(Cocoon.java:183)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
    at org.apache.tomcat.core.Handler.service(Handler.java:286)
    at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
    at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
    at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
    at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
    at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
    at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
    at java.lang.Thread.run(Thread.java:498)

    Configuration:

    ...from xml file:
    <esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
    <esql:dburl>jdbc:mysql://localhost:3306/statements</esql:dburl>

    Tomcat Web Server/3.2.1 (JSP 1.1; Servlet 2.2; Java 1.3.0; Linux 2.2.16-22 x86; java.vendor=IBM Corporation); Cocoon 1.8.1; mySQL 3.23.30-gamma; mm jdbc driver 1.2c.

Re: Cocoon and mySQL

Posted by Berin Loritsch <bl...@apache.org>.
Is the driver in Cocoon's ClasPath?
  ----- Original Message ----- 
  From: Richard Thomas 
  To: cocoon-users@xml.apache.org 
  Sent: Wednesday, January 24, 2001 5:43 PM
  Subject: Cocoon and mySQL


  I think I have everything configured correctly, based on the error message,
  is there a cocoon related item I am missing?  Thanks.

  Error message:
   
  java.lang.RuntimeException: Error opening connection to dburl: jdbc:mysql://localhost:3306/statements
  at java.lang.Throwable.<init>(Throwable.java:96)
  at java.lang.Exception.<init>(Exception.java:44)
  at java.lang.RuntimeException.<init>(RuntimeException.java:49)
  at _opt._tomcat._webapps._cocoon._samples._sql._esql2.populateDocument(_esql2.java:162)
  at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97)
  at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:524)
  at org.apache.cocoon.Engine.handle(Engine.java:383)
  at org.apache.cocoon.Cocoon.service(Cocoon.java:183)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
  at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
  at org.apache.tomcat.core.Handler.service(Handler.java:286)
  at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
  at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
  at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
  at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
  at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
  at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
  at java.lang.Thread.run(Thread.java:498)

  Configuration:

  ...from xml file:
  <esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
  <esql:dburl>jdbc:mysql://localhost:3306/statements</esql:dburl>

  Tomcat Web Server/3.2.1 (JSP 1.1; Servlet 2.2; Java 1.3.0; Linux 2.2.16-22 x86; java.vendor=IBM Corporation); Cocoon 1.8.1; mySQL 3.23.30-gamma; mm jdbc driver 1.2c.

Re: Cocoon and mySQL

Posted by Donald Ball <ba...@webslingerZ.com>.
yOn Wed, 24 Jan 2001, Richard Thomas wrote:

> I think I have everything configured correctly, based on the error message,
> is there a cocoon related item I am missing?  Thanks.

nope. your database url is incorrect, it would appear.

> Error message:
>
> java.lang.RuntimeException: Error opening connection to dburl:
> jdbc:mysql://localhost:3306/statements

- donald