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 10:42:46 GMT
On śro, mar 05, 2003 at 09:33:50 +0100, Torsten Curdt wrote:
> >>>Am I right that even though I can use prepared statement I cannot rerun 
> >>>the
> >>>query several times without recreating the statement every time? I have 
> >>>a lot
> >>>of cases when I have to make a lot of same inserts basing on xml data 
> >>>from
> >>>request body.
> >>
> >>http://java.sun.com/docs/books/tutorial/jdbc/basics/prepared.html
> >
> >Yeah nice. That's obvious. I know how to do it in JDBC. Just asking if ESQL
> >supports it.
> 
> Ah.. sorry.
> 
> No, not yet. Care enough for a patch? :)
Sure, at least I can try. Please comment my idea. 

Instead of in-place execution:

<xsp:logic>
int i;
for ( i = 0; i < count; ++i ) {
	somevar = somearray[ i ];
	
	<esql:execute-query>
		<esql:query>select foo from bar where blah =
		<esql:parameter><xsp:expr>somevar</xsp:expr></esql:parameter></esql:query>
	<esql:results>
		<!-- standard stuff -->
	</esql:results>
	</esql:execute-query>

}
</xsp:logic>
you may do something like:

<esql:declare-prepared-query id="prepared-no1">
	select foo from bar where blah = <esql:parameter name="firstparam"/>
</esql:declare-prepared-query>

<xsp:logic>
int i;
for ( i = 0; i < count; ++i ) {
	<esql:set-param query="prepared-no1" name="firstparam">
		<xsp:expr>somearray[ i ]</xsp:expr>
	</esql:set-param>

	<esql:run-prepared-query id="prepared-no1">
		<esql:results>
			<!-- standard stuff goes here -->
		</esql:results>
	</esql:run-prepared-query>
}
</xsp:logic>

What do you think ? 
	ouzo
-- 
            __
         | /  \ |        Leszek Gawron            //  \\
        \_\\  //_/      ouzo@vip.net.pl          _\\()//_
         .'/()\'.     Phone: +48(600)341118     / //  \\ \
          \\  //  recursive: adj; see recursive  | \__/ |


Mime
View raw message