3 Replies Latest reply on Feb 27, 2002 2:28 PM by Marcus Brito

    JBossCMP: wrong query generated for EJB-QL

    Marcus Brito Novice

      JBossCMP seems to be missing something from my EJB-QL. It's not generating the WHERE clause for my queries.

      The EJB-QL: SELECT OBJECT(o) FROM Linha o WHERE o.divisao.id = ?1

      The generated query: SELECT LINHA_ID FROM LINHAS

      It's missing the "WHERE DIVISAO_ID = ?1". Perhaps the parses is not navigating the CMR field "divisao"?

      Attached goes the ejb-jar.xml and jbosscmp-jdbc.xml file for these entities. Both were genereted by XDoclet.