Paul, Have you put the mysql driver class in your web.xml file?
<init-param> <param-name>load-class</param-name> <param-value> ... org.gjt.mm.mysql.Driver </param-value> </init-param> HTH, Andre. On Thursday, February 28, 2002, at 01:17 , Paul Caton wrote: > I'm running Cocoon 2.01 under Tomcat 4.0.2 and Java 1.3.1 on MacOS > X. I've set up a MySQL database called picodb. In my cocoon.xconf file > I've set up the connection as follows: > > <jdbc name="picodb_mysql_pool"> > <pool-controller min="5" max="10"/> > <auto-commit>true</auto-commit> > <dburl>jdbc:mysql://[hostname]/picodb</dburl> > <user>nobody</user> > <password></password> > </jdbc> > > (Obviously I have the real host name in my actual file) > > I've created an XSP page to query the database and it accords exactly > with all the example ESQL pages I've seen in the various Cocoon > tutorials. However, when I call that page I get the message: > > org.apache.cocoon.ProcessingException: Exception in > ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not > get the datasource > org.apache.avalon.excalibur.datasource.NoAvailableConnectionException: > There are no connections in the pool, check your settings > > > I've successfully interacted with the database as user "nobody" using > PHP, so I know the database is up and running. I've checked that the > MySQL driver is being loaded as an <init-param> in the web.xml file; > I've also checked that the correct MySQL driver class is in the > mm.mysql-2.0.11-bin.jar file in /WEB-INF/lib/. I've checked the FAQ > and mailing list archives, and I see that other people have had a > similar problem, but I've tried all the suggestions I've seen so far > (eg. checking the MySQL driver class is really there; putting 3306 as > the port number on the <dburl> value) and nothing has worked. Does > anyone have any other ideas I might try? > > Paul. --------------------------------------------------------------------- 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]>