Hello there!

I need to do a count using multiple columns but I get the following error:

expecting CLOSE, found '('

I searched a lot about this issue and my conclusion is that hibernate does not support count(distinct t.col, t.col2) or something like that. The table I want to do this count has a composite id and once this is a very basic functionality (I can do it in native SQL with no dificulty) I belive it must be a way to do that.

My last try was:

select count(distinct acr.id.numeroSinistro, acr.id.numeroAcordo) from AcordoORM as acr

then i got

select count( acordoorm0_.SINNUM, acordoorm0_.rscacrnum ) from mfrmacr acordoorm0_

but my oracle database does not run that query....


anyone has any idea on how to do this?

regards

looking at HQL grammar it seems it realy does not support multiple columns on a count expression:

aggregate
: ( SUM^ | AVG^ | MAX^ | MIN^ ) OPEN! additiveExpression CLOSE! { #aggregate.setType(AGGREGATE); }
// Special case for count - It's 'parameters' can be keywords.
| COUNT^ OPEN! ( STAR { #STAR.setType(ROW_STAR); } | ( ( DISTINCT | ALL )? ( path | collectionExpr ) ) ) CLOSE!
| collectionExpr
;

//## collection: ( OPEN query CLOSE ) | ( 'elements'|'indices' OPEN path CLOSE );

collectionExpr
: (ELEMENTS^ | INDICES^) OPEN! path CLOSE!
;

=(