[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-1700) HAVING clause not supported in Criteria API

HAVING clause not supported in Criteria API ------------------------------------------- Key: HHH-1700 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1700 Project: Hibernate3 Issue Type: New Feature Components: query-criteria Affects Versions: 3.1.3 Environment: Hibernate 3.1.3, Oracle 10g (not DB specific) Reporter: Manuel Dominguez Sarmiento Assignee: Diego Pires Plentz Priority: Minor Attachments: CustomProjections.java Original Estimate: 2 hours Remaining Estimate: 2 hours Currently the Criteria API does not support the HAVING clause. I have create a factory class which creates Projection instances using sqlGroupProjection. Probably not the best approach, but an idea which could be further developed. These factory methods could be included in the Projections factory class. Usage example w/one property: criteria.setProjection(CustomProjections.groupByHaving("id", Hibernate.LONG, "count(distinct id) >= 3")); Also allows aliases: criteria.setProjection(CustomProjections.groupByHaving("id", "idAlias", Hibernate.LONG, "count(distinct idAlias) >= 3")); Usage example w/many properties: String[] columns = new String[2]; columns[0] = "id"; columns[1] = "name"; String[] aliases = new String[2]; aliases[0] = "idAlias"; aliases[1] = "nameAlias"; Type[] types = new Type[2]; types[0] = Hibernate.LONG; types[1] = Hibernate.STRING; criteria.setProjection(CustomProjections.groupByHaving(columns, aliases, types, "count(distinct id) >= 3 and name='george'"));