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 03:41:17 UTC

esql and mySQL - What am I missing?

Hi y'all,

I'm just trying to pull some simple data from a database but I get the following error.  Any clues?  I have obviously misconfigured something.  Thanks.

java.lang.RuntimeException: Error loading driver: org.gjt.mm.mysql.Driver
	at java.lang.RuntimeException.<init>(RuntimeException.java:49)
	at _opt._tomcat._webapps._cocoon._samples._sql._esql2.populateDocument(_esql2.java:141)
	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)

The start of my xml document:

<?xml version="1.0"?>

<?cocoon-process type="xsp"?>
<?cocoon-process type="xslt"?>
<?xml-stylesheet type="text/xsl" href="esql2.xsl"?>

<xsp:page
  xmlns:xsp="http://www.apache.org/1999/XSP/Core"
  xmlns:esql="http://apache.org/cocoon/SQL/v2"
>

<page>

<esql:connection>
  <esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
  <esql:dburl>jdbc:mysql://localhost/test</esql:dburl>
.........

The driver entry in the cocoon.properties file:

processor.xsp.pool.database.adaptor.DBMySQL=org.gjt.mm.mysql.Driver

Re: esql and mySQL - What am I missing?

Posted by Donald Ball <ba...@webslingerZ.com>.
On Tue, 23 Jan 2001, Richard Thomas wrote:

> Hi y'all,
>
> I'm just trying to pull some simple data from a database but I get the
> following error.  Any clues?  I have obviously misconfigured
> something.  Thanks.

you're missing the mysql driver from your servlet engine's classpath.

- donald