Problem connecting to MySQL

2004-06-18 Thread Guy Picton Phillipps
Dear Listers, I am a newbie with Apache Cocoon and am trying my hand connecting to a MySQL database, with some difficulty. I have researched alot and still cannot find the answer to this problem. First the background info: Cocoon 2.1.5 Tomcat 5.0.27 mysql-3.23.38 j2sdk1.4.2_04 mysql-connector-j

RE: Problem connecting to MySQL

2004-06-19 Thread Guy Picton Phillipps
Hi Tony, Thanks for going through the details and confirming that it is OK. I did restart Tomcat after copying the mysql.jar to the tomcat lib directory. I wondered if the SQL Transformer had 'broken' or I had a bad install, so I reinstalled all the components yesterday, but to no effect. I tried

RE: Problem connecting to MySQL - Solved

2004-06-21 Thread Guy Picton Phillipps
Problem now solved - it appears that the DB connection parameters needed to be defined in the sitemap, not in the input XML. The answer came from documentation on the SQL Transformer on the Apache Cocoon site - http://cocoon.apache.org/2.1/userdocs/transformers/sql-transformer.html So the sitemap

Multiple SQL Queries

2004-06-30 Thread Guy Picton Phillipps
Hello, I am trying to configure a pipeline that will perform multiple queries on different tables in the same database and output the result to a single XML file, with the individual queries being differentiated by , etc. In the SQL transformer literature, there is reference to performing a s