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
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
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
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:
document xmlns:sql=xmlns:sql=http://apache.org/cocoon/sql/2.0;
and then just use:
sql:execute-query
sql:use-connectionward_connect/sql:use-connection
sql:queryselect admin_name from wards;/sql:query
/sql:execute-query
Whoops, wow, my mail client *really* likes to mangle