Ah! That's good to know. I can't use Java 1.4.1 because of the old Oracle 8i JDBC driver I'm using but I will try running it under cocoon 2.0.3 to see if its a 2.1 bug.
Thanks again. Simon Koen Pellegrims wrote: > oops, I just ran your example on my machine, and it ran like a charm :-s > > I must say I'm running tomcat 4.0.4, cocoon 2.0.3 on java 1.4.0... > > Koen > > >>-----Oorspronkelijk bericht----- >>Van: Simon Price [mailto:[EMAIL PROTECTED]] >>Verzonden: vrijdag 30 augustus 2002 14:53 >>Aan: [EMAIL PROTECTED] >>Onderwerp: Re: problems generating input to sql transformer with >>stylesheet (a la Langham & Ziegeler book) >> >> >>Koen, thanks but I already tried this. The resultant xml using your >>stylesheet is... >> >><?xml version="1.0" encoding="UTF-8"?> >><user xmlns:xmlns:sql="http://apache.org/cocoon/SQL/2.0";> >> <xmlns="http://apache.org/cocoon/SQL/2.0";> >> <> >> <>ecsnp</> >> <>Price</> >> <>Simon</> >> </> >> </> >></user> >> >>It sort of works but, for some reason, the rowset, row and column name >>tags get omitted by the sql transformer!!! >> >>In case it helps anyone say why this is, here's the intermediate xml >>from the stylesheet, before it goes into the sql transformer... >> >><?xml version="1.0" encoding="UTF-8"?> >><user xmlns:sql="http://apache.org/cocoon/SQL/2.0";> >> <sql:execute-query> >> <sql:use-connection>pool-TAL</sql:use-connection> >> <sql:query> >> select >> USERNAME, >> SURNAME, >> INITIALS >> from >> STAFF >> where >> STAFFID = '24' >> </sql:query> >> </sql:execute-query> >></user> >> >>Koen Pellegrims wrote: >> >> >>>try your stylesheet as follows: >>> >>> <?xml version="1.0"?> >>> <xsl:stylesheet version="1.0" >>> xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; >>> xmlns:sql="http://apache.org/cocoon/SQL/2.0";> >>> <xsl:template match="bootstrap"> >>> <user> >>> <sql:execute-query> >>> <sql:use-connection>pool-TAL</sql:use-connection> >>> <sql:query> >>> select >>> USERNAME, >>> SURNAME, >>> INITIALS >>> from >>> STAFF >>> where >>> STAFFID = '24' >>> </sql:query> >>> </sql:execute-query> >>> </user> >>> </xsl:template> >>> </xsl:stylesheet> >>> >>>this is exactly the same approach you would take to generate fo, for >>>example. >>> >>>Koen. >>> >>> >>> >>>>-----Oorspronkelijk bericht----- >>>>Van: Simon Price [mailto:[EMAIL PROTECTED]] >>>>Verzonden: vrijdag 30 augustus 2002 13:03 >>>>Aan: [EMAIL PROTECTED] >>>>Onderwerp: problems generating input to sql transformer with stylesheet >>>>(a la Langham & Ziegeler book) >>>> >>>> >>>>I'm having real problems doing a "trivial" tranformation (in the style >>>>of Matthew and Carsten's excellent book). >>>> >>>>I generate xml which then gets transformed by the sql transformer. >>>>Unfortunately, it only works if I have no containing elements in the >>>>input to the transformer. I'm guessing its related to the namespace? Or >>>>is it a bug in the sql transformer? Any suggestions welcomed! >>>> >>>>Here's the full details (stripped down to simplest repro so please don't >>>>worry about the stylesheet now being pointless)... >>>> >>>> >>>>version info: >>>> >>>>tomcat 4.0.1 >>>>java 1.3.1 >>>>cocoon 2.1 head >>>> >>>> >>>>sitemap fragment: >>>> >>>> <map:match pattern="test3.xml"> >>>> <map:generate src="model/bootstrap.xml"/> >>>> <map:transform src="model/staff_model.xsl"/> >>>> <map:transform type="sql"/> >>>> <map:serialize type="xml"/> >>>> </map:match> >>>> >>>> >>>>model/bootstrap.xml: >>>> >>>><?xml version="1.0"?> >>>><bootstrap/> >>>> >>>> >>>>model/staff_model.xsl >>>> >>>><?xml version="1.0"?> >>>><xsl:stylesheet version="1.0" >>>> xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; >>>> xmlns:sql="http://apache.org/cocoon/SQL/2.0";> >>>> <xsl:template match="bootstrap"> >>>> <user> >>>> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";> >>>> <use-connection>pool-TAL</use-connection> >>>> <query> >>>> select >>>> USERNAME, >>>> SURNAME, >>>> INITIALS >>>> from >>>> STAFF >>>> where >>>> STAFFID = '24' >>>> </query> >>>> </execute-query> >>>> </user> >>>> </xsl:template> >>>></xsl:stylesheet> >>>> >>>> >>>>error in browser (reformatted by hand to make more readable): >>>> >>>>Multiple colons are not allowed in a name. Error processing resource >>>>'http://localhost:8080/cocoon/tal/admin/test3.xml'. Line 2, Position 18 >>>> >>>><user xmlns:xmlns:sql="http://apache.org/cocoon/SQL/2.0";> >>>> -----------------^ >>>> <rowset xmlns="http://apache.org/cocoon/SQL/2.0"; >>>>xmlns:sql="http://apache.org/cocoon/SQL/2.0";> >>>> <row> >>>> <username>ecsnp</username> >>>> <surname>Price</surname> >>>> <initials>S</initials> >>>> </row> >>>> </rowset> >>>></user> >>>> >>>>To help diagnose, the intermediate XML that comes out of the stylesheet >>>>transformation, before going into the sql transformer is: >>>> >>>> <?xml version="1.0" encoding="UTF-8" ?> >>>> <user xmlns:sql="http://apache.org/cocoon/SQL/2.0";> >>>> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";> >>>> <use-connection>pool-TAL</use-connection> >>>> <query>select USERNAME, SURNAME, INITIALS from STAFF where STAFFID = >>>>'24'</query> >>>> </execute-query> >>>> </user> >>>> >>>>Contrast this with the XML at the same point if the root <user> element >>>>is removed from the stylesheet (THIS ONE WORKS): >>>> >>>> <?xml version="1.0" encoding="UTF-8" ?> >>>> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0"; >>>>xmlns:sql="http://apache.org/cocoon/SQL/2.0";> >>>> <use-connection>pool-TAL</use-connection> >>>> <query>select USERNAME, SURNAME, INITIALS from STAFF where STAFFID = >>>>'24'</query> >>>> </execute-query> >>>> >>>> >>>>Thanks in advance >>>> >>>>Simon >>>> >>>>------------------------------------------------------------------- >>>>Simon Price >>>>Institute for Learning and Research Technology >>>>University of Bristol >>>>8-10 Berkeley Square >>>>Bristol BS8 1HH >>>>United Kingdom >>>> >>>>Direct: +44 (0)7071 226 720 >>>>Office: +44 (0)117 928 7193 >>>>Fax: +44 (0)117 928 7112 >>>>[EMAIL PROTECTED] >>>>http://www.ilrt.bristol.ac.uk >>>> >>>> >>>> >>>>--------------------------------------------------------------------- >>>>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]> >>>> >>>> >>> >>>--------------------------------------------------------------------- >>>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]> >>> >> >>-- >> >>------------------------------------------------------------------- >>Simon Price >>Institute for Learning and Research Technology >>University of Bristol >>8-10 Berkeley Square >>Bristol BS8 1HH >>United Kingdom >> >>Direct: +44 (0)7071 226 720 >>Office: +44 (0)117 928 7193 >>Fax: +44 (0)117 928 7112 >>[EMAIL PROTECTED] >>http://www.ilrt.bristol.ac.uk >> >> >>--------------------------------------------------------------------- >>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]> >> >> > > > --------------------------------------------------------------------- > 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]> > -- ------------------------------------------------------------------- Simon Price Institute for Learning and Research Technology University of Bristol 8-10 Berkeley Square Bristol BS8 1HH United Kingdom Direct: +44 (0)7071 226 720 Office: +44 (0)117 928 7193 Fax: +44 (0)117 928 7112 [EMAIL PROTECTED] http://www.ilrt.bristol.ac.uk --------------------------------------------------------------------- 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]>
