Hibernate criteria returns empty list but data exists. Using annotation

Question

I can't figure out why this query isn't giving me any result. I know the data exists in the table. The list variable "results" is empty when the query is executed. Am I implementing the composite key correctly?

I even tried using the @EmbeddedId to get this done but the returned list was still empty.

        Session sess = HibernateUtil.getSession();
        Criteria criteria = sess.createCriteria(Employee.class);
        criteria.add(Restrictions.eq("employeeId", 255847208));
        criteria.add(Restrictions.eq("serialId", 461));
        List<Employee> results = criteria.list();

Primary key class

public class EmpPrmryKey implements Serializable {
        private Integer employeeId;
        private Integer serialId;
        //getters and setters
}

POJO Mapped to Table:

@Entity
@IdClass(EmpPrmryKey.class)
@Table(name = "EMPLOYEE")
public class Employee{

    private EmpPrmryKey compositeId;

    @Id
    @Column(name = "employee_id")
    private Integer employeeId; 

    @Id
    @Column(name = "serial_id")
    private Integer serialId;

    //getters and setters
}

Mathews · Accepted Answer · 2014-09-24 16:28:36Z

3

For those who are still looking for an answer to this question as I was, Please check your hibernate config xml and make sure your hibernate entity is declared there.

answered Sep 24, 2014 at 16:28

Mathews

8991 gold badge7 silver badges13 bronze badges

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

Comments

Nikita Vlasenko · Accepted Answer · 2016-07-21 04:32:28Z

1

I just had almost identical problem and my issue was that in applicationContext.xml I had a wrong package name specified for scanning for sessionFactory. Interestingly, Eclipse did not show me any exceptions, errors, so to debug it was extremely hard:

<bean id="sessionFactory"
    class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
    <property name="dataSource" ref="dataSource" />
    <property name="packagesToScan" value="{{Wrong Package Name}}" />
</bean>

answered Jul 21, 2016 at 4:32

Nikita Vlasenko

4,3828 gold badges56 silver badges96 bronze badges

Comments

Nikoloz · Accepted Answer · 2013-11-14 21:45:55Z

0

First of all, I guess you don't need private EmpPrmryKey compositeId; in Employee class.

I created local project with the same entities and the same query you provided worked (it returned expected result). So, If result still empty then you may check if you are looking correct table or database.

answered Nov 14, 2013 at 21:45

Nikoloz

5531 gold badge3 silver badges11 bronze badges

Comments

addicted20015 · Accepted Answer · 2017-01-04 11:47:43Z

0

Adding to @nikita;s answer, please check for the property with name annotatedClasses in the sessionFactory bean id (applicationContext.xml). Tt would be something like this :

<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
  <property name="dataSource" ref="dataSource" />
  <property name="annotatedClasses">
    <list>
      <value>com.your.package.Employee</value>
    </list>
  </property>
</bean>

answered Jan 4, 2017 at 11:47

addicted20015

6441 gold badge7 silver badges16 bronze badges

Collectives™ on Stack Overflow

Hibernate criteria returns empty list but data exists. Using annotation

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related