JBossCMP: wrong query generated for EJB-QL

[pazu]

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.

[dsundstrom]

The old EJB-QL compiler in 3.0beta did not print error messages when it was passed bad ejb-ql.

My guess is that o.divisao is collection valued or o.divisao.id is not the same type as parameter 1 (EJB-QL is strongly typed).

If you can't figure it out, try the new EJB-QL compiler is CVS (yes, you will have to build from source).

[pazu]

The problem was with <declared-sql> elements. Once I removed all <declared-sql>'s, the problem was gone. I think I got the wrong idea about this element. I'll look into the new JBoss-QL to do sorting.

[pazu]

Now, Dain, could you please take a loo at my other post (http://main.jboss.org/thread.jsp?forum=46&thread=9793)