cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Schroeter Christian <Christian.Schroe...@nbg.sbs.de>
Subject Cocoon 1.8.2 + MySQL + JDBC + Win2000 + Tomcat
Date Wed, 28 Nov 2001 16:00:17 GMT
Hi,

as i read here in the mailling-list and in the internet, there are more 
people who have problems to create an jdbc-connection to MySQL. At the moment 
i also try to establish such a connection.

But it is not working, and i do not know why. Can anybody help?

I am using MySQL (Version 3.23.38), Cocoon 1.8.2, Tomcat 3.2.3, Win2000
I used this jdbc-driver: mm.mysql-2.0.6.1.jar
I copied them into TOMCAT_HOME/lib

My cocoon.property-File has this:

# These are your database settings, look in the
# org.apache.turbine.util.db.pool.* package for more information.
processor.xsp.pool.database.db.driver=org.gjt.mm.mysql.Driver
processor.xsp.pool.database.db.url=jdbc:mysql:\\localhost\db
processor.xsp.pool.database.db.username=lothar
processor.xsp.pool.database.db.password=xxx
processor.xsp.pool.database.db.maxConnections=3
processor.xsp.pool.database.db.expiryTime=3600000

I try this both xml-Files to access the DB:

*** Without pool-connection:
Source of the page:

...
<esql:connection>
	<esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
	<esql:dburl>jdbc:mysql://localhost/db</esql:dburl>
	<esql:username>lothar</esql:username>
	<esql:password>xxx</esql:password>
....


I get this errormessage:

java.lang.RuntimeException: Error loading driver: org.gjt.mm.mysql.Driver
at 
_D_._Jakarta._Tomcat._jakarta_tomcat_3_2_3._webapps._cocoon._uebung3._uebung3d_db.populateDocument(_uebung3d_db.java:183)
at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97)
at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:527)
at org.apache.cocoon.Engine.handle(Engine.java:384)
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:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at 
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at 
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)


*** With pool-connection

...
<esql:connection>
	<esql:pool>db</esql:pool>
	         <esql:execute-query>
...

java.lang.RuntimeException: Error opening pooled connection: db: 
org.gjt.mm.mysql.Driver
at _D_._Jakarta._Tomcat._jakarta_tomcat_3_2_3._webapps._cocoon._uebung3._ue 
bung3c_db.populateDocument(_uebung3c_db.java:184)
at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97)
at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:5 
27)
at org.apache.cocoon.Engine.handle(Engine.java:384)
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:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at 
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at 
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)



cu,
Christian

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

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