0 Replies Latest reply on Sep 26, 2002 10:59 AM by Pete

    Incorrect SQL Generated, using XDoclet and Middlegen

    Pete Newbie

      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