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