Yeah,
I tried it on both too and especially with mysql it was a breeze ;-)
Mariano
On Friday 29 June 2001 09:33 am, Beauprez Sven wrote:
> Mariano,
>
> I tested the SQLTransformer with mysql and oracle as underlying databases,
> it should work fine on both...
> If you need an open source database, i certainly recommend mysql. I use the
> following jdbc driver: http://mmmysql.sourceforge.net/
>
>
> Sven
>
>
> -----Original Message-----
> From: Mariano Kamp [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 28, 2001 3:08 PM
> To: [EMAIL PROTECTED]
> Subject: Re: AW: [C2] Postgres with SQL - Transformer
>
>
> 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]>
>
> ---------------------------------------------------------------------
> 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]>
