Sven,
thank you very much for your response.
I see your point in polluting the code by providing the dynamic sql
opportunity to and furthermore prepared statements are the way to go anyway.
The exception says "it's not implemented *yet*", so as we are just looking
for *some* open source database to support, and I got mysql up and running
yesterday ,it is not pressing us anymore. As mentioned earlier we are
building a reporting system and performance is critical but transactions are
not, so for the time being mysql will just do fine.
Again, thanks for caring.
Mariano
On Thursday 28 June 2001 04:22 pm, Beauprez Sven wrote:
> Mariano,
>
> The latest version of the SQLTransformer (HEAD branch) uses prepared
> statements (for the queries) and callable statements (for stored
> procedures). It doesn't use the createStatement() on the connection object
> anymore. I removed it because i thought it would be an improvement to use
> prepared statements instead. (i thought all jdbc drivers implemented this,
> but it seems not all of them do :-( )
>
> I think the code will get messy if i incorporate the old way also, i will
> try to find a compromise for this...
>
> Someone an idea?
>
> In the meantime, the old version of the SQLTransformer in the
> cocoon_20_branch still uses createStatement(), maybe you can use this one
> for now.
>
>
> Sven
>
>
>
>
> -----Original Message-----
> From: Mariano Kamp [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 28, 2001 2:36 PM
> To: [EMAIL PROTECTED]
> Subject: [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: <[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]>
