Criteria API and count(*)

tradem · **Joined:** Mon Oct 06, 2003 1:59 am **Posts:** 52

Can I use the Criteria API to write a count(*) select?
If yes how? Unfortunalty the documentation does not talks about this.

Any thougths and advices are welcome ;).

Thx again for this fine product.

Bye
Toby

michael · **Posted:** Tue Jul 20, 2004 2:54 am

No, this is not yet possible.

tradem · **Joined:** Mon Oct 06, 2003 1:59 am **Posts:** 52

michael wrote:

No, this is not yet possible.

Okay.

Is there a workaround for this in HQL?

Code:

select count(bla.id) where like :object

I really like the #enableLike Method of Example class. Is there a equvalent for this in HQL???

Thx
Toby

michael · **Posted:** Tue Jul 20, 2004 7:18 am

No :)

tradem · **Joined:** Mon Oct 06, 2003 1:59 am **Posts:** 52

michael wrote:

No :)

Would be nice feature for Hibernate3 , wouldn't it?

:-D

flf-hibernate · **Joined:** Tue Mar 09, 2004 12:01 am **Posts:** 9

For Hibernate 3.x, you just need to use the following projection:

Code:

new SimpleProjection() {
  public String toSqlString(Criteria criteria, int position, CriteriaQuery criteriaQuery) {
       return "count(*) as y"+position+"_";
  }
}

See CountProjection source code for more info, for example if you want to support distinct, or other features.

Another simple solution is to just use a SqlProjection.

Fabien Le Floc'h.