cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mariano Kamp <mk...@codamax.com>
Subject Re: [C2] Postgres with SQL - Transformer
Date Fri, 29 Jun 2001 07:42:18 GMT
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:mkamp@codamax.com]
> Sent: Thursday, June 28, 2001 2:36 PM
> To: cocoon-users@xml.apache.org
> 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: <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