cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mariano Kamp <mk...@codamax.com>
Subject Re: AW: [C2] Postgres with SQL - Transformer
Date Thu, 28 Jun 2001 13:07:34 GMT
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: <cocoon-users-unsubscribe@xml.apache.org>
> > For additional commands, e-mail: <cocoon-users-help@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: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message