1 Reply Latest reply on Jun 6, 2003 1:08 AM by crazytony

    Wierd find with ejbql problem

    crazytony Newbie

      I am running 3.2.1 and mysql.

      I have a finder that returns a collection of objects.

      For some reason the finder is running the EJB-QL query:
      SELECT t0_d.account_id FROM users t0_d WHERE t0_d.account_id = ?
      Which returns 4 ids (Correct)

      JBoss then runs:
      SELECT full_name, alias, account_id FROM users WHERE (account_id=?)

      4 times in a row and only selects the first record.

      This seems strange to me, and it's just this finder

      Here is my EJBQL:

      SELECT OBJECT(d) FROM UserInfo d WHERE d.accountId = ?1