File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Hibernate MySQL5Dialect registerFunction limit Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate MySQL5Dialect registerFunction limit" Watch "Hibernate MySQL5Dialect registerFunction limit" New topic

Hibernate MySQL5Dialect registerFunction limit

Luis Parente
Ranch Hand

Joined: Jan 17, 2012
Posts: 39

I have hibernate ORM with the implementation JPA, I have registered some functions like that:

The class extends of org.hibernate.dialect.MySQL5Dialect and it's work perfectly.

But now I want to register de function LIMIT, and I do the following:

but when I use it in my JPQL, exemple : Select From ProductEntity pte LIMIT 1, Hibernate trows an exception....

Could you help me with this stuff.

Thanks in advance.

Best regards.

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: Hibernate MySQL5Dialect registerFunction limit
jQuery in Action, 3rd edition