Hibernate Community • View topic - hibernate.query.substitutions for functions with parameters

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

hibernate.query.substitutions for functions with parameters

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

Post subject: hibernate.query.substitutions for functions with parameters

Posted: Thu Jun 29, 2006 9:37 am

Beginner

Joined: Sat Jan 29, 2005 8:49 pm
Posts: 20

Hibernate version:
3.1.3

Is there a nice way to make a substitution of a function that needs extra parameters?

ORACLE
week(date) -> TO_CHAR(date, 'WW')

MSSQL
week(date) -> FORMAT(date, 'WW')

would be cool to have something like that

Code:

<property name="hibernate.query.substitutions">week TO_CHAR($1, 'WW')</property>

Top

Post subject: works, but ...

Posted: Thu Jun 29, 2006 2:57 pm

Beginner

Joined: Sat Jan 29, 2005 8:49 pm
Posts: 20

ok it is possible to write a hql query like this

Code:

"select to_char(mc.date, 'ww') from mc"

and i found that all the functions are defined in the dialect implementation org.hibernate.dialect.Dialect.java but i still think it would be nice to have a way to make a call to a StandardSQLFunction using a substitution parameter.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum