[prev in list] [next in list] [prev in thread] [next in thread] 

List:       xml-cocoon-users
Subject:    Re: PreparedStatement
From:       Christian Haul <haul () dvs1 ! informatik ! tu-darmstadt ! de>
Date:       2003-10-14 8:24:16
[Download RAW message or body]

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


[prev in list] [next in list] [prev in thread] [next in thread]