cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Leszek Gawron <o...@vip.net.pl>
Subject Re: ESQL and prepared statements
Date Wed, 05 Mar 2003 13:14:40 GMT
On śro, mar 05, 2003 at 07:47:19 -0500, Geoff Howard wrote:
> At 07:37 AM 3/5/2003, you wrote:
> >On 05.Mar.2003 -- 11:42 AM, Leszek Gawron wrote:
> >> you may do something like:
> 
> <snip-proposal/>
> 
> 
> >Sounds reasonable. Although I fear changes to esql.xsl and helper
> >classes might be cosiderable to achieve this.
> >
> >This would lead to the question: Is it worth it? I mean, in my book
> >ESQL should be used to generate content only, not for update,
> >insert or delete. And for that it's probably less often useful to
> >repeat a query a number of times. Would be different of course, if the
> >statement would be kept over different invocations of the page (the
> >driver or the DBMS might do it for prepared statements).
> >
> >        Chris.
> 
> I thought JDBC3 drivers were supposed to automatically pool and reuse 
> prepared statements "for free".  No?
even if, both pervasive and ms sql server driver are JDBC 2.0 only and M$ does
not plan to release JDBC 3.0 compliant version
	ouzo
-- 
            __
         | /  \ |        Leszek Gawron            //  \\
        \_\\  //_/      ouzo@vip.net.pl          _\\()//_
         .'/()\'.     Phone: +48(600)341118     / //  \\ \
          \\  //  recursive: adj; see recursive  | \__/ |


Mime
View raw message