You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Mariano Kamp <mk...@codamax.com> on 2001/06/28 14:35:59 UTC
[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?
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: AW: [C2] Postgres with SQL - Transformer
Posted by Mariano Kamp <mk...@codamax.com>.
Hallo Carsten,
thanks for answering my question and sorry for not being more specific in
first place.
Yes I am using connection pooling configured in cocoon.xconf, but the
funny thing is I was also using connection pooling when using esql and that
was working ok.
I don't think that the problem is related to the avalon code. The stack
trace showed that the exeception was raised in postgresql classes.
Unfortunately I don't have access to the running system today, but if you
want I can post it tomorrow.
Well, yes and we need connection pooling and we also want to use an open
source database besides oracle. As we are reporting data and don't need
transactions I will have a look at mysql now.
Bis bald,
Mariano
On Thursday 28 June 2001 02:49 pm, you wrote:
> > Mariano Kamp wrote:
> > Von: Mariano Kamp [mailto:mkamp@codamax.com]
> > Gesendet: Donnerstag, 28. Juni 2001 14:36
> > An: cocoon-users@xml.apache.org
> > 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: cziegeler@sundn.de
> ================================================================
>
> > 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: <co...@xml.apache.org>
> > For additional commands, e-mail: <co...@xml.apache.org>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
AW: [C2] Postgres with SQL - Transformer
Posted by Carsten Ziegeler <cz...@sundn.de>.
> Mariano Kamp wrote:
> Von: Mariano Kamp [mailto:mkamp@codamax.com]
> Gesendet: Donnerstag, 28. Juni 2001 14:36
> An: cocoon-users@xml.apache.org
> 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: cziegeler@sundn.de
================================================================
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>