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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
