How to using substring in Hibernate HQL?

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

Hi everyone:

Does someone use substring function in Hibernate? I know in MySQL the function is called "SUBSTRING" ,but in Oracle this function is written to "substr". I want to my application don't dependence any database. So Hibernate support any function like "substring" ? I mean how to cut substring in HQL?
Thks

david · **Posted:** Thu Dec 16, 2004 9:42 pm

Currently, the funstions are defined in the dialect so there is no Hibernate alias where substitution occurs. We talked a little about it some time ago but it is not the focus. The new parser will make all of these type of features much easier to add going forward.

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

david wrote:

Currently, the funstions are defined in the dialect so there is no Hibernate alias where substitution occurs. We talked a little about it some time ago but it is not the focus. The new parser will make all of these type of features much easier to add going forward.

Do you mean that Hibernate 3 will support it? Or other alternative method can do this? Expecting some idea. Thks

pvradhakrishna · **Joined:** Tue Feb 19, 2008 6:05 pm **Posts:** 82

So cast(substring(someString,3),integer) works for both MySql and Oracle, but why do we have so many substr functions in Hibernate HQL and where can we know the usage of each one of these functions?