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