> Mariano Kamp wrote:
> Von: Mariano Kamp [mailto:[EMAIL PROTECTED]]
> Gesendet: Donnerstag, 28. Juni 2001 14:36
> An: [EMAIL PROTECTED]
> Betreff: [C2] Postgres with SQL - Transformer
>
>
> Hi there,
>
> I tried C2 with postgress, but postgres throws an exeption that
> prepareStatement() is not supported yet ;-( Is there any way to tell the
> SQL-Transformer not to prepare the Statements and use dynamic sql instead?
>
I am not quiet sure but I think the prepareStatement comes from the
underlying
Avalon databasesource code. Am I correct that you use preconfigured sql
connections in the cocoon.xconf?
If so the only solution is to don't use them and write your connection
directly into the sitemap when the transformer is used:
<map:transform type="sql">
<map:parameter name="dburl" value="your db url"/>
<map:parameter name="username" value="your username"/>
<map:parameter name="password" value="your password"/>
</map:transform>
Using this no prepareStatement() is called (I hope) but the bad news: no
connection pooling.
Carsten
Open Source Group sunShine - b:Integrated
================================================================
Carsten Ziegeler, S&N AG, Klingenderstrasse 5, D-33100 Paderborn
www.sundn.de mailto: [EMAIL PROTECTED]
================================================================
> Mariano
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
