I have an old problem on a new machine ;-( The new machine, where I have just done a 'clean' installation of an app that runs without any problems on my machine (and on the local Unix box) has the following config: - Windows2000 - IIS - Tomcat 4.0.01 - Cocoon 2.0 - mySQL 3.23.xx
Cocoon itself runs fine, as do the test hssql database samples, as does the non-database part of the app. The problems arises when I try to connect to the mySQL database and get a: org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not get the datasource java.sql.SQLException: There are no connections in the pool, check your settings. A search through the mail archives shows that this is *usually* a problem with the web.xml file. Here are my various DB-related entries in the web.xml and cocoon.xconf files: <init-param> <param-name>load-class</param-name> <param-value> <!-- For IBM WebSphere: com.ibm.servlet.classloader.Handler --> <!-- For Database Driver: --> org.hsqldb.jdbcDriver <!-- mySQL Database Driver: --> org.gjt.mm.mySQL.Driver </param-value> </init-param> <!-- connection for database --> <jdbc name="indicators_user"> <pool-controller min="5" max="50"/> <auto-commit>true</auto-commit> <dburl>jdbc:mysql://nn.nn.nn.nn/indicators</dburl> <user>username</user> <password>pword</password> </jdbc> I think the problem *might* be with the [hostname] in the <dburl> setting, as Tomcat does not run off the localhost [there is *no* localhost on this machine] but off nn.nn.nn.nn:8080. I have tried various combinations of settings eg.: jdbc:mysql://nn.nn.nn.nn/ jdbc:mysql://nn.nn.nn.nn:3306/ jdbc:mysql://localhost/ jdbc:mysql://localhost:3306/ PLEASE - I really need to get this app working at the client asap, (yesterday,, possible ;-) and did not anticipate these "basic" problems - I am sure I am missing something simple here and would appreciate any insight. Thanks Derek --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>