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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]