Online Hibernate Training just in Rs. 1000

One week online training in Hibernate ORM framework. Learn Hibernate Framework and enhance your skills. Best Online Hibernate training at 90% discount. Join Now!! Offer is valid Only for limited Period!!! Online Training Big Data and Hadoop Training Java Training  

Calling hibernate query list() method generates errors



Share on Google+Share on Google+

Calling hibernate query list() method generates errors
1 Answer(s)      6 years and 4 months ago
Posted in : Hibernate


I'm trying to debug someone's codes. But I am not an expert of hibernate so I'm asking your help about this.

I am trying to retrieve a list of jobs from the database, but there seems to be a problem.

In the entity class:


@ManyToOne(cascade={CascadeType.MERGE, CascadeType.REFRESH}, fetch=FetchType.EAGER)
@JoinColumn(name="job_id", nullable=false)
private Job jobId;

private String grpId;

@Column(name="id", nullable=false)
private Integer id;


public Collection<JobEntity> getJobsByGrpId(String grpId){
    Query q = getCurrentSession().createQuery("from JobEntity je where je.grpId= :grpId order by");

    q.setString("grpId", grpId);

    return q.list();

And the error I get is something like this:

No row with the given identifier exists: [Job#:jb4567]...

But in the db, the table has data.

I'm not sure what's reason for this.

I tried putting a getCurrentSession.flush()

statement before creating the query, and I also tried changing the cascade type of the job id from REFRESH to PERSIST, but still the same errors occur.

Does cache have anything to do with this? Or, what seems to be the problem here? I'm clueless already.

Thanks in advance for the answers...

View Answers

April 5, 2011 at 6:35 PM