entity bean strategy on-find doesnt seem to work ??

[sudhirsrinivasan]

hi here are my class level entity bean settings

<ejb-name>Alert</ejb-name>
<read-ahead>
on-load
<page-size>150</page-size>
<eager-load-group>*</eager-load-group>
</read-ahead>

This doesnt seem to take effect. If i use a query
@jboss.query
* signature = "Collection findByTspRange (java.sql.Timestamp startTsp,java.sql.Timestamp endTsp )"
* query = "SELECT OBJECT(a) FROM Alert a WHERE a.alertTsp>= ?1 and a.alertTsp<?2"

Here are the sqls executed.
2005-04-27 17:32:58,814 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Alert] Executing SQL: SELECT event_id, pnum, alert_severity_cd, alert_status_cd, alert_tsp, return_value, host_id, message FROM alert WHERE (alert_id=?)
2005-04-27 17:32:59,261 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Alert] Executing SQL: SELECT event_id, pnum, alert_severity_cd, alert_status_cd, alert_tsp, return_value, host_id, message FROM alert WHERE (alert_id=?)
2005-04-27 17:32:59,379 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Alert] Executing SQL: SELECT event_id, pnum, alert_severity_cd, alert_status_cd, alert_tsp, return_value, host_id, message FROM alert WHERE (alert_id=?)
2005-04-27 17:32:59,607 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Alert] Executing SQL: SELECT event_id, pnum, alert_severity_cd, alert_status_cd, alert_tsp, return_value, host_id, message FROM alert WHERE (alert_id=?)
2005-04-27 17:32:59,616 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Alert] Executing SQL: SELECT event_id, pnum, alert_severity_cd, alert_status_cd, alert_tsp, return_value, host_id, message FROM alert WHERE (alert_id=?

Using jboss 3.2.3 .. Im really suprised this doesnt seem to work as advertised or am I mistaken ?

-sudhir

[demarco]

Execute your finder and the collection iteration in one transaction. f.e. generate a sessionbean and a method with transaction required.The entity transaction state should always be transaction required. In this method call the finder and make the iteration.
if you are using a remote client directly accessing the entitys then a user transaction is reuqired.