cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "OD" ...@feersumendjinns.com>
Subject Re: XML and SQL using MySQL
Date Mon, 09 Oct 2000 13:44:48 GMT
Hi,

The quick and dirty option would be to copy mm.mysql-2.0.2-bin.jar to to the
lib\ext directory in either the jre or the jdk directory.
Um I think the paths for a default Java install are:
C:\Program Files\JavaSoft\JRE\1.3\lib\ext
C:\jdk1.3\jre\lib\ext

Or you could try adding it to your servlet containers path

For Tomcat you'd copy it to %TOMCAT_HOME%/lib
then edit %TOMCAT_HOME%/bin/tomcat.bat
and add the line:
set CLASSPATH=%CLASSPATH%;%TOMCAT_HOME%\lib\mm.mysql-2.0.2-bin.jar

Corey O'Donovan

----- Original Message -----
From: Martin Bouman <M.Bouman@telecats.nl>
To: <cocoon-users@xml.apache.org>
Sent: Monday, October 09, 2000 2:28 PM
Subject: XML and SQL using MySQL


> Dear Sir / Madam,
>
> Recently I tried to use the SQL TagLib from Cocoon 1.8 with Access 97.
> Because this did'nt work I searched for an alternative DBMS and came up
with
> MySQL for Windows NT 4.0 (which is running perfectly!).
>
> To use the SQL TagLib from within a XML-file I used the JDBC driver from
> Mark Matthews at http://www.worldserver.com/mm.mysql/ and put it in the
> Windows User Environment:
>
> Classpath
> c:\mysql\lib\mm.mysql-2.0.2-bin.jar
>
> The only problem occuring when I try to view taglib.xml from
> hhtp://localhost/taglib.xml is:
>
> Error found handling the request.
> java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
> at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
> at java.security.AccessController.doPrivileged(Native
> Method)
> at
> java.net.URLClassLoader.findClass(URLClassLoader.java:188)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:297)
> at
> sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:286)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
> at
> java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)
> at java.lang.Class.forName0(Native Method)
> at java.lang.Class.forName(Class.java:120)
> at
>
org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.executeQuery(XSPSQ
> LLibrary.java:157)
> at
> _C_._Apache._htdocs._taglib.populateDocument(_taglib.java:134)
> at
> org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:96)
> at
>
org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:494)
> at org.apache.cocoon.Engine.handle(Engine.java:359)
> at org.apache.cocoon.Cocoon.service(Cocoon.java:167)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
> at
> org.apache.jserv.JServConnection.processRequest(JServConnection.java:317)
> at
> org.apache.jserv.JServConnection.run(JServConnection.java:188)
> at java.lang.Thread.run(Thread.java:484)
>
> Why can't it find the driver?
>
>
> I hope someone knows the answer.
>
>
> Martin Bouman
> TeleCats BV, The Netherlands
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org


Mime
View raw message