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
Found it, sorry.
I had the wrong PK specified.