Groups > comp.lang.java.programmer > #33571

A few JPQL questions

From	Cecil Westerhof <Cecil@decebal.nl>
Newsgroups	comp.lang.java.programmer
Subject	A few JPQL questions
Date	2016-02-03 08:46 +0100
Organization	Decebal Computing
Message-ID	<871t8ume1f.fsf@Equus.decebal.nl> (permalink)

Show all headers | View raw

I do not have very much experience with JPA and especially with JPQL.
Yesterday shortly before leaving my colleague told me that he could
not use an embedded key in JPQL. He told me that when he used
something like:
    a.id = b.id
he got more records as when he used:
    a.id.first = b.id.first AND a.id.second = b.id.second …

I had not the time to evaluate this, but it seems very strange to me.
Could this be true? If so, what would be the reason? Otherwise, which
mistake has he likely made?

He also told me it was not possible to do a JOIN on a sub-query in
JPQL. He said it is only possible to use WHERE and HAVING. I assume he
made a mistake. What is most likely he did wrong?

-- 
Cecil Westerhof
Senior Software Engineer
LinkedIn: http://www.linkedin.com/in/cecilwesterhof

Back to comp.lang.java.programmer | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

A few JPQL questions Cecil Westerhof <Cecil@decebal.nl> - 2016-02-03 08:46 +0100
  Re: A few JPQL questions Cecil Westerhof <Cecil@decebal.nl> - 2016-02-03 09:28 +0100
  Re: A few JPQL questions Lew <lewbloch@gmail.com> - 2016-02-03 13:32 -0800

csiph-web