2 Replies Latest reply on Aug 22, 2002 4:48 AM by Les Green

    Generated SQL misses table name

    Les Green Newbie

      This is probably something simple I have overlooked but if anyone could point out what I am missing I would be mighty grateful. I have a finder declared through xdoclet

      @ejb:finder
      signature="Collection findByCheckPointIDAndTop(java.lang.String checkPointID, java.lang.String top)
      transaction-type="Required"
      query="SELECT DISTINCT OBJECT(o) FROM CheckPoint o WHERE o.checkPointID=?1 AND o.top=?2"

      which prompts the output from JBoss 3.0.1 when the finder is deployed of:

      [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.CheckPoint.findByCheckPointIDAndTop] EJB-QL: SELECT DISTINCT OBJECT(o) FROM CheckPoint o WHERE o.checkPointID=?1 AND o.top=?2
      2002-08-19 16:33:41,734 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.CheckPoint.findByCheckPointIDAndTop] SQL: SELECT t0_o.checkpoint FROM t0_o WHERE t0_o.checkPointID = ? AND t0_o.top = ?

      and gets an object not found from the database call - it appears to lose the table name somewhere??

      Any help would be appreciated.

      Lynke.