I'm using the latest middlegen and xdoclet to create my CMP 2.0 entity bean classes from my mysql database. I am having middlegen generate finder methods as well. For some reason, the SQL generated from the EJB-QL is incorrect:
EJB-QL: SELECT DISTINCT OBJECT(o) FROM BoboT o WHERE o.someId = ?1
SQL: SELECT DISTINCT FROM bobo_t t0_o WHERE t0_o.someID = ?
(notice the DISTINCT (blank) FROM in the SQL)
I have attached my ejb-jar.xml and jbosscmp-jdbc.xml files