I had this problem when I put the mm.mysql jar in the tomcat library 6 months ago. The problem with the jar I had was in the paths for the drivers in the jar ( take a look in your jar ).
I worked around the problem by unzipping the files - and copying them so the path matched. marty > -----Original Message----- > From: Schroeter Christian [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 28, 2001 11:00 AM > To: [EMAIL PROTECTED] > Subject: Cocoon 1.8.2 + MySQL + JDBC + Win2000 + Tomcat > > > 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._u > ebung3._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(XSPProces > sor.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(ContextM > anager.java:812) > at > org.apache.tomcat.core.ContextManager.service(ContextManager.java:758) > at > org.apache.tomcat.service.http.HttpConnectionHandler.processCo > nnection(HttpConnectionHandler.java:213) > at > org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoin > t.java:416) > at > org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPo > ol.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._u > ebung3._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(XSPProces > sor.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(ContextM > anager.java:812) > at > org.apache.tomcat.core.ContextManager.service(ContextManager.java:758) > at > org.apache.tomcat.service.http.HttpConnectionHandler.processCo > nnection(HttpConnectionHandler.java:213) > at > org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoin > t.java:416) > at > org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPo > ol.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]> --------------------------------------------------------------------- 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]>
