join « Eclipse « JPA Q&A

  1. JPA Q&A
  2. Eclipse
  3. join




1. JPA: JOIN in JPQL    stackoverflow.com

I thought I know how to JOIN in JPQL but apparently not. Can anyone help me? 

select b.fname, b.lname from Users b JOIN Groups c where c.groupName = :groupName
This give me Exception 
org.eclipse.persistence.exceptions.JPQLException
Exception ...

2. HQL join / with using EclipseLink    stackoverflow.com

How does one express the following HQL query in EclipseLink : 

from Cat as cat
left join cat.kittens as kitten
with kitten.bodyWeight > 10.0
It appears that with is not supported. Is there something equivalent ...

3. JPA one-to-many unidirectional relationship using a join table    stackoverflow.com

I would like to evaluate JPA on an existing project. The database model and the java classes exists and are currently mapped via self generated code. The database model and the ...

4. JPA, NamedQueries strange beaviour with JOIN on two tables    stackoverflow.com

this is my first Java code. I'm trying to obtain a RESTfull web service that returns a view on a database JSON encoded. The result that i want (not json encoded) in ...

5. Can't understand EclipseLink warning    stackoverflow.com

I'm using EclipseLink 2.3.1 to model self referencing table with JPA 2. I get weird warning from EclipseLink when I create the EntityManager. 

[EL Warning]: 2011-11-27 14:28:00.91--ServerSession(8573456)--Reverting the lazy setting on the OneToOne ...