title: Calling hibernate query list() method generates errors
body: <p>I'm trying to debug someone's codes. But I am not an expert of hibernate so I'm asking your help about this.</p>
  
  <p>I am trying to retrieve a list of jobs from the database, but there seems to be a problem.</p>
  
  <p>In the entity class:</p>
  
  <p><code>//JobEntity</code></p>
  
  <pre><code>    @ManyToOne(cascade={CascadeType.MERGE, CascadeType.REFRESH}, fetch=FetchType.EAGER)
      @JoinColumn(name="job_id", nullable=false)
      private Job jobId;
  
      @Column(name="grp_id")
      private String grpId;
  
      @Id
      @Column(name="id", nullable=false)
      @GenericValue(strategy=GenerationType.SEQUENCE,generator="JOB_ENTITY_SEQUENCE")
      private Integer id;
  
  
  //DaoImpl
  
      public Collection&lt;JobEntity&gt; getJobsByGrpId(String grpId){
          Query q = getCurrentSession().createQuery("from JobEntity je where je.grpId= :grpId order by je.id");
  
          q.setString("grpId", grpId);
  
          return q.list();
      }
  </code></pre>
  
  <p>And the error I get is something like this:</p>
  
  <pre><code>No row with the given identifier exists: [Job#:jb4567]... 
  </code></pre>
  
  <p>But in the db, the table has data.</p>
  
  <p>I'm not sure what's reason for this.</p>
  
  <p>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.</p>
  
  <p>Does cache have anything to do with this?
  Or, what seems to be the problem here? I'm clueless already.</p>
  
  <p>Thanks in advance for the answers...</p>