cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Simon Price <simon.pr...@bristol.ac.uk>
Subject Re: problems generating input to sql transformer with stylesheet (a la Langham & Ziegeler book)
Date Fri, 30 Aug 2002 12:52:56 GMT
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:     <cocoon-users-unsubscribe@xml.apache.org>
>>For additional commands, e-mail:   <cocoon-users-help@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:     <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail:   <cocoon-users-help@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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message