Hibernate version: 3.0.5

HI, I have a pretty silly question about Modulo Operation in HQL.
How can I use it in a HQL query.

I think I missed a function Name or operator for this.
My Searching on the Forum and on the Internet had no success in finding any infomration about this topic.
It seems to me that hibernate does not support this Operation in HQL.
Documentation does not even contain the word modulo.
Perhaps it is non Standard, but it is a needed fucntion.

My query looks like:
---------------------------------------------------------------------------------
SELECT a FROM Cat a WHERE (a.age % a.numberOfChilds) > 10
---------------------------------------------------------------------------------

Hibernate Exception:
org.hibernate.QueryException: unexpected char: '%'

I am looking for a way to use this Modulo Operation without Native SQLQuery.
Is there any Solution you know. Maybe a secret operation name, or a way to enhance Hibernate to add this Operation.

Thanks in advance to all of you, who are reading this.
I hope you can help me.

If HQL doesn't support modulo then you can always just use a native SQL query. Providing your DB supports it of course, but it is part fo the ANSI-92 standard.

Hi, as I wrote before I know it is possible to use SQLQuery but I am looking for a way to use HQL for solving this problem.

But thanks for the try.

Create a custom dialect with your own SQLFunction.

Quick fix, a little dirty but simple:

SELECT a FROM Cat a WHERE (a.age - a.age / a.numberOfChilds * a.numberOfChilds) > 10

Actually, the SQL posted above works for some databases, but it doesn't work at least for Oracle, because Oracle never does integer division, it always converts to floating point.

Here's some modulo SQL that works in Hibernate and works in all the databases I'm aware of:

a % b =>

select cast((cast(a as real)/cast(b as real) - cast(cast(a as real)/cast(b as real) -0.5 as integer)) * cast(b as real) as integer)