Hi Jann,

Thanks, yes we have activated the SQL Transformer in our sitemap.

In the <map:pipelines> section we added:

     <map:transform type="sql">
        <map:parameter name="use-connection" value="MyPoolName"/>
        <map:parameter name="show-nr-of-rows" value="true"/>
        <map:parameter name="clob-encoding" value="UTF-8"/>
<map:parameter name="namespace-uri" value="http://apache.org/cocoon/SQL/2.0"/>
      </map:transform>

--Arne

Jann Forrer wrote:
Hi Arne
I am getting an error when trying to run a query.

error: unknown element "execute-query" from namespace
"http://apache.org/cocoon/SQL/2.0";

I've following the example for here:
http://cocoon.apache.org/2.1/userdocs/sql-transformer.html

Do I have the wrong namespace?

We are running Lenya 2.0.1 and connecting to MySQL 5.0.51a

Did you activate the SQL Transformer in your sitemap?

<map:transformer name="sql" logger="sitemap.transformer.sql"
src="org.apache.cocoon.transformation.SQLTransformer">

We use the SQL Transfomrer in lenya 1.2 and it works fine.

Jann


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]


!DSPAM:7,4a1f834e38661859910370!



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to