users@glassfish.java.net

join fetch bug on Toplink Essentials

From: <glassfish_at_javadesktop.org>
Date: Sun, 12 Aug 2007 05:14:03 PDT

Hi,

  I'm usgin GF V2b58 (RC1) and Toplink can't parse

        "select distinct tceAtivo from TCEAtivo tceAtivo join fetch tceAtivo.tce t join fetch t.duracoesTCE where tceAtivo.tce.estagiario.matricula = :matricula";

Caused by: Exception [TOPLINK-8025] (Oracle TopLink Essentials - 2.0 (Build b58-rc1 (08/04/2007))): oracle.toplink.essentials.exceptions.EJBQLException
Exception Description: Syntax error parsing the query [select distinct pedido from PedidoTCE pedido join fetch pedido.tce t join fetch t.duracoesTCE where pedido.tce.estagiario.matricula = :matricula], line 1, column 68: unexpected token [t].
Internal Exception: line 1:68: unexpected token: t

    The same query runs ok on JBoss AS 4.0.5.GA.

    Thanks for any help.

    Leandro
[Message sent by forum member 'leandro_komosinski' (leandro_komosinski)]

http://forums.java.net/jive/thread.jspa?messageID=230575