Hello!
I am using JBoss jboss-3.0.2_tomcat-4.0.4. I am having a strange
behavior with a dynamic query. The problem is that the data returned by
my dynamic query (1) isn't kept in memory and than (when I start the
iteration through the results) another select is executed (2), which
returns exactly the same data. All the code should be executing in one
only transaction (according to my code). I have tried to change the
read-ahead policy from "on-find" to "on-load", but nothing changes. I
don't seem to have control over the dynamic query. Is any one
experiencing this behavior? Can any one help me, please?
Thanks in advance,
Victor Batista
//////////////////////////////
(1)
Executing SQL: SELECT t0_u.username, t0_u.name, t0_u.surname,
t0_u.passwd, t0_u.int_num, t0_u.description, t0_u.creation_date FROM
DC_USERS t0_u WHERE t0_u.username IN(?, ?, ?) ORDER BY t0_u.name ASC
(2)
Executing SQL: SELECT username, name, surname, passwd, int_num,
description, creation_date FROM DC_USERS WHERE (username=?) OR
(username=?) OR (username=?) FOR UPDATE
//////////////////////////////
jbosscmp-jdbc excerpt with "on-find" strategy. I have also tried with
"on-load" with different "page-size" values, always with the result
above (including for page-size=1).
<query>
<query-method>
<method-name>findAllIn</method-name>
<method-params>
<method-param>java.lang.String</method-param>
<method-param>java.lang.Object[]</method-param>
</method-params>
</query-method>
<dynamic-ql/>
<read-ahead>
<strategy>on-find</strategy>
</read-ahead>
</query>
-------------------------------------------------------
This sf.net email is sponsored by: To learn the basics of securing
your web site with SSL, click here to get a FREE TRIAL of a Thawte
Server Certificate: http://www.gothawte.com/rd524.html
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
