You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Simon Price <si...@bristol.ac.uk> on 2002/08/30 18:16:33 UTC
Re: problems generating input to sql transformer with stylesheet (a la Langham & Ziegeler book)
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:simon.price@bristol.ac.uk]
>>Verzonden: vrijdag 30 augustus 2002 14:53
>>Aan: cocoon-users@xml.apache.org
>>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:simon.price@bristol.ac.uk]
>>>>Verzonden: vrijdag 30 augustus 2002 13:03
>>>>Aan: cocoon-users@xml.apache.org
>>>>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
>>>>Simon.Price@bristol.ac.uk
>>>>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: <co...@xml.apache.org>
>>>>For additional commands, e-mail: <co...@xml.apache.org>
>>>>
>>>>
>>>
>>>---------------------------------------------------------------------
>>>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: <co...@xml.apache.org>
>>>For additional commands, e-mail: <co...@xml.apache.org>
>>>
>>
>>--
>>
>>-------------------------------------------------------------------
>>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
>>Simon.Price@bristol.ac.uk
>>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: <co...@xml.apache.org>
>>For additional commands, e-mail: <co...@xml.apache.org>
>>
>>
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
--
-------------------------------------------------------------------
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
Simon.Price@bristol.ac.uk
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
[SUMMARY] problems generating input to sql transformer with stylesheet (a la Langham & Ziegeler book)
Posted by Simon Price <si...@bristol.ac.uk>.
Adding this line to the stylesheet fixes the bug.
<xsl:output method="text"/>
In fact the problem turned out to have absolutely nothing to do with the
sql transformer; the problem was earlier in the pipeline but was
masked because the xml piped into the transformer appeared okay when
inspected using a view. However, although it serializes and displays in
the browser, any attempt to transform the subsequent xml that comes out
of the stylesheet creates an error.
I only discovered this when I started shortening the pipeline and also
found that if I cut+pasted the xml from the stylesheet transformation
into a text file, it worked fine if loaded by a file generator and
immediately piped into the sql transformer!
I assume its a bug in one of cocoon's components.
Go figure :-(
Simon
Simon Price wrote:
> 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:simon.price@bristol.ac.uk]
>>> Verzonden: vrijdag 30 augustus 2002 14:53
>>> Aan: cocoon-users@xml.apache.org
>>> 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:simon.price@bristol.ac.uk]
>>>>> Verzonden: vrijdag 30 augustus 2002 13:03
>>>>> Aan: cocoon-users@xml.apache.org
>>>>> 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
>>>>> Simon.Price@bristol.ac.uk
>>>>> 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: <co...@xml.apache.org>
>>>>> For additional commands, e-mail: <co...@xml.apache.org>
>>>>>
>>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> 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: <co...@xml.apache.org>
>>>> For additional commands, e-mail: <co...@xml.apache.org>
>>>>
>>>
>>> --
>>>
>>> -------------------------------------------------------------------
>>> 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
>>> Simon.Price@bristol.ac.uk
>>> 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: <co...@xml.apache.org>
>>> For additional commands, e-mail: <co...@xml.apache.org>
>>>
>>>
>>
>>
>> ---------------------------------------------------------------------
>> 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: <co...@xml.apache.org>
>> For additional commands, e-mail: <co...@xml.apache.org>
>>
>
>
--
-------------------------------------------------------------------
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
Simon.Price@bristol.ac.uk
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>