2 Replies Latest reply on Sep 26, 2002 2:47 PM by dsundstrom

    Error in Jboss 3.0.2 Generated SQL using XDoclet and Middleg

    peteclark3

      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 Jboss 3.0.2 generates 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