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.
--
Paul Caton
Electronic Publications Editor
Women Writers Project
e-mail: [EMAIL PROTECTED]
tel: (401) 863-3619
address: Box 1841, Brown University, Providence RI 02912
---------------------------------------------------------------------
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]>
