CODEWITHSUNDEEP
javahibernate
Amowe B
Amowe B

Reputation: 45

counting row or records using hibernate

I have been trying to count number of rows using hibernate but I keep getting "0" records. Here is my code

public static Integer getLastDrugId(){
    Integer result = 0;
    Session session = HibernateUtil.getSessionFactory().openSession();
    Transaction tx = null;
    try{
        tx = session.beginTransaction();
        String hql = "SELECT count(*) FROM Drug";
        Query query = session.createQuery(hql);
        Integer e = (Integer) query.iterate().next();
        if (e != null) {
            result = 1;
        }

    } catch (Exception ex) {
        if (tx != null) {
            tx.rollback();
        }
    } finally {
        session.close();
    }
    return result;
}

Am i getting it wrong somewhere?

Upvotes: 0

Views: 364

Answers (1)

R Dhaval
R Dhaval

Reputation: 546

Replace this line :

Integer e = (Integer) query.iterate().next();

whith this:

Long e = (Long) query.iterate().next();

Upvotes: 0

Related Questions