Hi,

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