cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gerard Pille" <>
Subject Bind variables not really bind variables?
Date Tue, 05 Apr 2005 11:26:09 GMT

our developers use the following syntax:

      select tk.taalcde_code as taalcode, tk.flg_moedtaal as
             tk.eval_bgrp, tk.eval_lezen, tk.eval_schrij, tk.eval_sprk
     from talenkennis tk, taalcodes tc 
     where tc.code = tk.taalcde_code and ikl_num_seq =

In the database's (Oracle 9) sql area, I find thousands of these
statements, only differing from each other by the literal value of the
esql:parameter.  The database does not receive a query with a bind
variable, which would be more advantageous for memory and performance.

Is something wrong with this syntax or does Cocoon (v 2.1.5) not really
translate this construct into a java prepareStatement.


Gerard H. Pille

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message