How does hibernate handl sql-functions in hql-where clause?

pletzma · **Joined:** Thu Aug 25, 2005 5:43 am **Posts:** 2

Hello,
despite I read http://www.hibernate.org/hib_docs/v3/re ... yhql-where
it is not clear for me how hibernate handles sql-functions in hql-where clause.
E.g. we use to_date('2004/10/10','YYYY/MM/DD'). I guess to_date() is non standard SQL at any DB.
So I want to know if I am barking up the right tree.
My clue is:
Hibernate passes sql-functions to the underlying DB without converting or translating. True or False?
How does hibernate detect sql-functions?

Thanks for help.

greets,
martin

gcormier · **Joined:** Thu Aug 18, 2005 4:34 pm **Posts:** 33

I think it handles only certain ones, for others you will have to write a native SQL query.

pksiv · **Posted:** Thu Aug 25, 2005 4:13 pm

pletzma wrote:

Hello,
despite I read http://www.hibernate.org/hib_docs/v3/re ... yhql-where
it is not clear for me how hibernate handles sql-functions in hql-where clause.
E.g. we use to_date('2004/10/10','YYYY/MM/DD'). I guess to_date() is non standard SQL at any DB.
So I want to know if I am barking up the right tree.
My clue is:
Hibernate passes sql-functions to the underlying DB without converting or translating. True or False?
How does hibernate detect sql-functions?

Thanks for help.

greets,
martin

For functions that aren't predefined, you can extend the Dialect you are using and register the new functions.

in your case it might be something like

Code:

registerFunction( "to_date", new SQLFunctionTemplate(Hibernate.STRING, "to_date(?1,'YYYY/MM/DD')") );