1) You must have jdbc driver file in classpath 2) Check your cocoon.xconf for <datasources>...</datasources> for pool configuration 3) See access.log for message like this DEBUG (2002-03-26) 17:04.45:713 [access] (Unknown-URI) Unknown-thread/Cocoon Servlet: Trying to load class: org.gjt.mm.mysql.Driver
----- Original Message ----- From: "Derek Hohls" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 4:43 PM Subject: Database connection problem > When trying to connect to a mySQL database, I get: > > Could not get the datasource java.sql.SQLException: There are no > connections in the pool, check your settings. > > I already have the setting for the driver in the web.xml; > <init-param> > <param-name>load-class</param-name> > <param-value>org.gjt.mm.mysql.Driver</param-value> > </init-param> > > I can also connect to, and 'see' the database with another, front-end > program. > > In fact, the connection AND database were working previously - does > anyone know if a mod_rewrite for the site in the Apache server would > affect this?? (seems strange, but thats the only major change that has > happened on the server that I know about) I have also checked the > connection without using the VirtualHost and get the same results... > > Any ideas as to what else to check? > > Thanks > Derek > > --------------------------------------------------------------------- > 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]>
