[JPA] EJBQL query returns replicated result of same record

[antonio each]

Hi all

this is my scenario:

public class Car{
@ManyToOne();
@JoinColumn(name="CAR_TYPE_ID")
private CarType carType;
......
......
}
public class CarType{
@Column(name="CAR_TYPE_ID")
private long carTypeId;
@Column(name="CAR_DESC")
private String carDesc;
@OneToMany(mappedBy="carTypeId")
private Set<Car> carList;
}

So i have a NamedQuery on top of Car entity:

SELECT c FROM Car c WHERE c.carType.carDesc = 'MONOVOLUME'

In my database I have only one car which have CAR_DESC = 'MONOVOLUME',but query return the same replicated result sixteen times!

I can't see any error in my code,can someone help me?

Thank you!
Antonio

[Arun Kumarr]

Why are you not using carTypeId as a join condition?

[James Sutherland]

What is the SQL generated?