1 Reply Latest reply on May 23, 2005 12:11 PM by Marco Zanker

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

    sudhir Newbie

      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