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:[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]>
---------------------------------------------------------------------
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]>
