[news.eclipse.rt.eclipselink] Re: Is JPA QL supposed to be this picky?

[christoph.john@xxxxxxxx (Christoph John)]

Hi,

I was about to create an almost similar post.
The problem appears also on EclipseLink 1.1. But it seems it is longer in 
the code than that, since 1.0 also had this issue (at least for me).

The thing is that it doesn't happen on TopLink Essentials. I wanted to 
switch the persistence provider on GlassFish to EclipseLink and ran into 
this problem.

The working query for me was:

SELECT p FROM CombinedTraderMappingBean t, PriceStepBean p
WHERE t.memberId     = :memberId
AND   t.traderId     = :traderId
AND   t.exchangeId   = p.exchangeId;

If I only swap the beans in the FROM clause it won't work.

Cheers
Chris.

Josh Davis wrote:
[...]
> The SQL generator did not use the table alias t1 in the select clause.