Guy Picton Phillipps wrote:
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.
&snip;
Hmm, everything looks kosher. It appears the SQLTransformer is not
Tony Collen wrote:
http://apache.org/cocoon/sql/2.0";>
and then just use:
ward_connect
select admin_name from wards;
Whoops, wow, my mail client *really* likes to mangle namespace declarations. Ignore the literal
text, and just try declaring the sql namespace in the root tag, and see if i
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
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