Hibernate MySQL5Dialect registerFunction limit

[Luis Parente]

Hello,

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

   registerFunction("group_concat", new StandardSQLFunction("group_concat", StringType.INSTANCE) );
    registerFunction("extract_value", new StandardSQLFunction("Extractvalue", StringType.INSTANCE) );

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:

   registerFunction("limit_func", new StandardSQLFunction("Limit", StringType.INSTANCE) );

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.