cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "warrell harries" <warrell.harr...@googlemail.com>
Subject Re: Problem with SQLTransformer
Date Thu, 26 Jul 2007 12:47:10 GMT
oooops, thanks for pointing that out, Florian.

Perhaps it's because I have been (who hasn't?) bewildered by the vagaries of
Xalan and namespaces enough times to always use the sql: prefix ;-)


On 26/07/07, Dev at weitling <dev1@weitling.net> wrote:
>
>
>
> warrell harries wrote:
> > From the xml snippet it appears that you have missed out the sql: prefix
> >
> > One of those infuriating 'can't see for looking' things perhaps
>
> This shouldn't be a problem 'cause the default namespace for
> execute-query and below  is set correct.
>
> Florian
>
> > On 26/07/07, Michel Gutierrez <michel.gutierrez@gmail.com> wrote:
> >> There is certainly a stupid reason but i've spend a few hours to make
> >> the SQLTransformer work without success. Hopefully someone will point
> me
> >> out what i'm doing wrong.
> >>
> >> I try to use the sql transformation but the xml goes through the
> >> transformer sheet unchanged, the <sql:xxx> elements are not executed
> and
> >> reach the serializer.
> >>
> >> The source XML: sql-select-themes.xml
> >> <?xml version="1.0"?>
> >> <page>
> >>         <execute-query xmlns="http://apache.org/cocoon/SQL/v2">
> >>                 <query>SELECT nom FROM Theme</query>
> >>         </execute-query>
> >> </page>
> >>
> >> The transformer declaration:
> >> <map:transformer logger="sitemap.transformer.sql" name="sql"
> >>         src="org.apache.cocoon.transformation.SQLTransformer"/>
> >>
> >> The sitemap pipeline:
> >>         <map:match pattern="themes">
> >>                 <map:generate type="file" src="sql-select-themes.xml"/>
> >>                 <map:transform type="sql">
> >>                         <map:parameter name="use-connection"
> >> value="fmshsql"/>
> >>                 </map:transform>
> >>                 <map:serialize type="xml"/>
> >>         </map:match>
> >>
> >> I can see from the log that a SQLTransformer component is being
> >> instantiated, but it does nothing and i get the exact
> >> sql-select-themes.xml at the end of the pipeline.
> >>
> >> I know my DB setup is ok, as i can access the SQL server using esql in
> a
> >> serverpages generator.
> >>
> >> Can someone let me know what my mistake is ?
> >>
> >> Thanks,
> >> Marie
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> >> For additional commands, e-mail: users-help@cocoon.apache.org
> >>
> >>
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>

Mime
View raw message