Eclipse Community Forums: EclipseLink » JPQL problems with JOIN FETCH on List<Entity>

Help

Home

Home » Eclipse Projects » EclipseLink » JPQL problems with JOIN FETCH on List<Entity>

Show: Today's Messages :: Show Polls :: Message Navigator

JPQL problems with JOIN FETCH on List<Entity> [message #1061964]

Wed, 05 June 2013 07:41

F C

Messages: 12
Registered: June 2013

Junior Member

Hi,
I use EclipseLink 2.4 and JPA 2.0.
I have the following entities:

@Entity
@Table(name = "EMPLOYERS")
public class Employer implements Serializable {
...
@Id
@Column(name="ID")
private String id;

private String name;

private String surname;

@OneToMany(mappedBy="employer", fetch=FetchType.EAGER)
private List<Employee> list;
...
}

and

@Entity
@Table(name = "EMPLOYEES")
public class Employee implements Serializable {
...

@ManyToOne
@JoinColumn(name="ID", insertable=false, updatable=false)
private Employer employer;

...
}

Now, my jpql is:
StringBuilder query = new StringBuilder();
query.append("SELECT employer FROM Employer employer ");
query.append("JOIN FETCH employer.list list ");
query.append("WHERE ");
query.append("UPPER(employer.id) = ?1 ");

So, the generated SQL query is:
/* Formatted on 2013/06/05 09:16 (Formatter Plus v4.8. Cool

*/
SELECT ....
FROM employees t0, employees t2, employers t1
WHERE ( (UPPER (t1.id) = ?)
AND ((t0.id = t1.id) AND (t2.id = t1.id)
)
)

So, i can't understand why in FROM clause table EMPLOYEES appears two times.
Can someone help me?

Report message to a moderator

Re: JPQL problems with JOIN FETCH on List<Entity> [message #1062077 is a reply to message #1061964]

Wed, 05 June 2013 18:25

Chris Delahunt

Messages: 1239
Registered: July 2009

Senior Member

I can't tell from what was provided - are there any other Employer-Employee relationships? Is T0, T2 or both appearing in the select statement?

Report message to a moderator

Re: JPQL problems with JOIN FETCH on List<Entity> [message #1062970 is a reply to message #1062077]

Tue, 11 June 2013 14:44

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

You define your tables as uppercase, but the SQL you included is lower case, so either this is not the real code you are using, or not the real SQL that was generated?

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:	NamedQuery of name ... not found.
Next Topic:	JMS cache coordination on GlassFish cluster

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 26 09:13:57 GMT 2017

.:: Contact :: Home ::.