MySQL - No suitable driver

[Jan Willem Penterman <jw...@shapers.nl>]

I'm quite new to Cocoon but want to set up a MySQL connection using
ESQL. I followed the directives on
http://www.cocooncenter.de/cc/documents/resources/db-app/index.html and
altered the settings for MySQL like I see them everwhere in the mail
archives. So I have an XSP page generated from a subsitemap of the
default cocoon app:

<?xml version="1.0"?>
<xsp:page
	language="java"
	xmlns:xsp="http://apache.org/xsp"
	xmlns:esql="http://apache.org/cocoon/SQL/v2">
	<root>
		<esql:connection>
			<esql:execute-query>		
				<!-- pooling (doesn't work) -->
				<!-- esql:pool>mysql</esql:pool -->
				
				<!-- basic connection. no pooling
(doesn't work either) -->
	
<esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
	
<esql:dburl>jdbc:mysql://localhost:3306/test</esql:dburl>
				<esql:username>root</esql:username>
				<esql:password>5h4p3r5</esql:password>

				...				

			</esql:execute-query>
		
		</esql:connection>
	</root>
</xsp:page>

As you can see it doesn't work both pooling and non-pooling. This is the
error:

error.log:
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
opening connection to dburl: : No suitable driver

Traces I find of the driver:

access.log:
DEBUG   (2002-08-15) 02:32.20:253   [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Trying to load class:
org.gjt.mm.mysql.Driver

core.log:
DEBUG   (2002-08-15) 02:54.03:637   [core] (Unknown-URI)
Unknown-thread/Cocoon: Classpath =
<alotofjars/>;D:\apache-tomcat-4.0.4\webapps\cocoon\WEB-INF\lib\mm.mysql
-2.0.14-bin.jar;<alotofjars/>;

I can however make a jdbc:mysql connection with a regular servlet. So
nothing wrong with that.

My system:

Windows XP
j2sdk1.3.1_4
tomcat 4.0.4
cocoon 2.0.3
MySQL 3.23.49-nt
mm.mysql-2.0.14






---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <co...@xml.apache.org>
For additional commands, e-mail:   <co...@xml.apache.org>