You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Geert Van Damme <ge...@vdab.be> on 2003/10/14 10:15:06 UTC
PreparedStatement
Hi all,
The docs say a prepared statement is created whenever a <esql:parameter/> tag appears in the query. If I use this tag in a nested query (not a subquery in sql but a nested query in XSP), will the same prepared statement be used for every iteration or will the esql:parameter tag create a new prepared statement every time (which would kind of disable an important use of a prepared statement) ?
Thanks
Geert
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: PreparedStatement
Posted by Christian Haul <ha...@dvs1.informatik.tu-darmstadt.de>.
On 14.Oct.2003 -- 10:15 AM, Geert Van Damme wrote:
>
> Hi all,
>
> The docs say a prepared statement is created whenever a <esql:parameter/> tag appears in the query. If I use this tag in a nested query (not a subquery in sql but a nested query in XSP), will the same prepared statement be used for every iteration or will the esql:parameter tag create a new prepared statement every time (which would kind of disable an important use of a prepared statement) ?
It will create the statement multiple times. However, in theory the
driver should recognize the statement and reuse the previous one.
Chris.
--
C h r i s t i a n H a u l
haul@informatik.tu-darmstadt.de
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org