[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?