Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0
Name and version of the database you are using:MySQL

count(concat(g.id,g.bnum)) gives me this error:

expecting CLOSE, found '('

I even added this:
registerFunction("concat", new SQLFunctionTemplate ibernate.CHARACTER, "concat(?1, ?2)"));

but still It gives me the same error.

It seems that count can not be combined with other functions. So
I registered this function:

registerFunction( "count_distinct_concat", new SQLFunctionTemplate( Hibernate.INTEGER, "count(distinct concat(?1,?2))" ) );