Using hibernate return count value of a query

Question

this is my mysql query:

SELECT count(*) 
FROM bw_jobs 
WHERE year(job_date)=year(curdate()) AND month(job_date)=month(curdate());

How to use this in hibernate to get count value?

hi i got it . Tha answer is SessionFactory factory = HibernateUtil.getSessionFactory(); session = factory.openSession(); SQLQuery sqlQuery = session.createSQLQuery("SELECT count(*) as noofjobs FROM bw_jobs where year(job_date)=year(curdate()) and month(job_date)=month(curdate());"); sqlQuery.addScalar("noofjobs",Hibernate.INTEGER); Integer i=(Integer)sqlQuery.uniqueResult(); — Sureshkumar Menon
– Sureshkumar Menon, Commented May 1, 2011 at 13:20

JB Nizet · Accepted Answer · 2016-06-03 16:30:12Z

18

String hql = "select count(job.id) from Job job"
             + " where year(job.jobDate) = year(current_date())"
             + " and month(job.jobDate) = month(current_date())";
Query query = session.createQuery(hql);
return ((Number) query.uniqueResult()).intValue();

(assuming the bw_jobs table is mapped by the Job entity, and the job_date column is mapped to the jobDate property)

See http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html_single/#queryhql-expressions for the list of functions supported by Hibernate.

edited Jun 3, 2016 at 16:30

answered May 1, 2011 at 13:27

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Using hibernate return count value of a query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related