Hi Phil, On Sat, 5 Apr 2003, Phil Coultard wrote:
> Frustrated and feeling rather thick, Don't worry, I've spent many hours on db connection problems, it's always a sticking point and a nightmare to get sorted out. Here's some step-by-step checks (worth repeating, as typos are often the problem!): 1) Is the mysql server running and accepting connections? - Test this using the mysql command-line client: mysql -D your_db_name -h localhost -P 3306 -pyour_password -u your_user Make sure you can select the information you want to use in the XSP (to ensure the user you're connecting as has rights to the db and the table): SELECT foo FROM bar; - Test connections with telnet: telnet localhost 3306 (you should see something like "3.23.56-log$8,u+r}>" which shows you can at least connect to localhost) 2) Is the (right) mysql jar available? - Check that you downloaded the correct jar for your JDK, as jdbc connectors are java version-specific. - Check in $TOMCAT_HOME/webapps/cocoon/WEB-INF/lib/ for the presence of mysql-connector-java-3.0.6-bin.jar or similar. - Check that it is correctly referenced in WEB-INF/web.xml: <init-param> <param-name>load-class</param-name> <param-value> <!-- For Database Driver: --> com.mysql.jdbc.Driver </param-value> </init-param> 3) Is the Cocoon database connection pool configured? - Check that it's correctly configured in WEB-INF/cocoon.xconf: <datasources> <jdbc logger="core.datasources.your_db_name" name="your_db_name"> <pool-controller max="10" min="5"/> <dburl>jdbc:mysql://localhost:3306/your_db_name</dburl> <user>your_user</user> <password>your_password</password> </jdbc> </datasources> 4) Is the XSP written correctly? - Try the simplest possible XSP that could work, first: <?xml version="1.0"?> <xsp:page language="java" xmlns:xsp="http://apache.org/xsp" xmlns:esql="http://apache.org/cocoon/SQL/v2"> <page> <esql:connection> <esql:pool>your_db_name</esql:pool> <esql:execute-query> <esql:query>SELECT foo FROM bar</esql:query> <esql:results> <esql:row-results> <foo><esql:get-string column="foo"/></foo> </esql:row-results> </esql:results> </esql:execute-query> </esql:connection> </page> </xsp:page> That said, from looking at what you've done so far, you've got everything correct :-/ Andrew. -- Andrew Savory Email: [EMAIL PROTECTED] Managing Director Tel: +44 (0)870 741 6658 Luminas Internet Applications Fax: +44 (0)700 598 1135 This is not an official statement or order. Web: www.luminas.co.uk --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]