Hibernate Criteria - org.hibernate.QueryException: could not resolve property:

Question

I'm trying to use criteria for select the values from many-to-one releationship mapped field.But i'm getting errororg.hibernate.QueryException: could not resolve property:part_id of:. Please see my pojo classes and advise what is the wrong here.

Criteria partCriteria = session.createCriteria(PartFeatureVersion.class);
partCriteria.add(Restrictions.eq("part_id",part.getPart_id()));


@Entity
@Table(name="DBO.PART_FEATURE_VERSION")
public class PartFeatureVersion {
private Part part;

@ManyToOne(fetch=FetchType.LAZY)
    @JoinColumn(name="part_id")
    public Part getPart() {
        return part;
    }


@Entity
@Table(name="DBO.PART")
public class Part {

private String part_id;
    private Set<PartFeatureVersion> partfeatureversion = new HashSet<PartFeatureVersion>(0);

    @Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name="PART_ID")
public String getPart_id() {
    return part_id;
}

    @OneToMany(cascade=CascadeType.ALL,fetch=FetchType.LAZY,mappedBy="part")
public Set<PartFeatureVersion> getPartfeatureversion() {
    return partfeatureversion;
}

if create getters/setters in PartFeatureVersion pojo class , its giving error as org.hibernate.MappingException: Repeated column in mapping for entity:PART_ID (should be mapped with insert="false" update="false").

I'm not terribly familiar with Hibernate, but is it able to perform this mapping without setters for the mapped fields? — Chris Hayes
– Chris Hayes, Commented Dec 28, 2013 at 7:29
I am also not sure but it looks there is part_id should be in CAPS for @JoinColumn(name="part_id") — Ketan Bhavsar
– Ketan Bhavsar, Commented Dec 28, 2013 at 7:43
Make sure the name of columns match exactly as they are named in db. — coder hacker
– coder hacker, Commented Dec 28, 2013 at 7:58
I have tried part_id as caps in @JoinColumn(name="PART_ID", itdidn't work well.As well all db names are match with pojo classes. — user2848031
– user2848031, Commented Dec 28, 2013 at 8:10
Here getters and setters are not created in the pojo class, if i creating pojo then its error "org.hibernate.MappingException: Repeated column in mapping for entity:" — user2848031
– user2848031, Commented Dec 28, 2013 at 8:14

jocki · Accepted Answer · 2013-12-28 08:41:00Z

7

Change the following code:

partCriteria.add(Restrictions.eq("part_id",part.getPart_id()));

into:

partCriteria.add(Restrictions.eq("part", part));

The criteria in your code is based on PartFeatureVersion class. You are restricting the criteria based on PartFeatureVersion.part_id property. The problem is your PartFeatureVersion class doesn't have a property called part_id.

answered Dec 28, 2013 at 8:41

jocki

1,76816 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2848031 Over a year ago

I have changed the code , but now i'm getting error as org.hibernate.PropertyAccessException: IllegalArgumentException occurred calling getter of Part.part_id.

jocki Over a year ago

Do you forget to replace part.getPart_id() into part?

Uri Agassi · Accepted Answer · 2014-05-03 15:14:33Z

0

This happened to me.

I fixed it by matching the sintax's upper and lower case description field when used in the criteria, and match the fielname declared in the DTO class.

edited May 3, 2014 at 15:14

Uri Agassi

37.5k16 gold badges82 silver badges96 bronze badges

answered May 3, 2014 at 14:07

javaprogrammingmx

91 bronze badge

Collectives™ on Stack Overflow

Hibernate Criteria - org.hibernate.QueryException: could not resolve property:

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related