substring « HQL « JPA Q&A

1. can HQL do substring

Dear all, I am new to Hibernate. I am doing a project which uses Hibernate as the bridge to access database. My problem is: The user will give a zip code range(either 3 or 5 digits), I will have to get the total pieces of mails grouped by the 3-digit or 5-digit zip code. My problem is the data(zip code) in ...

2. How to using substring in Hibernate HQL?

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

3. how to use "substring" in the hql ????