Meaningless Drivel is fun!*
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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate MySQL5Dialect registerFunction limit" Watch "Hibernate MySQL5Dialect registerFunction limit" New topic
Author

Hibernate MySQL5Dialect registerFunction limit

Luis Parente
Ranch Hand

Joined: Jan 17, 2012
Posts: 39
Hello,

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 pte.id From ProductEntity pte LIMIT 1, Hibernate trows an exception....


Could you help me with this stuff.

Thanks in advance.


Best regards.


 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Hibernate MySQL5Dialect registerFunction limit
 
Similar Threads
group_concat in hibernate
Calling Stored Procedure from Hibernate mapping file
LEFt OUTER JOIN returning extraneous results...
Group concat in SQL server 2008
Best Practice For Joined Result Set