ORM Mapping: JPA
Issue: MySQLSyntaxErrorException on calling Stored Procedure
I am having issue in calling MYSQL Stored Procedure from a Hibernate JPA application.
I am calling the procedure as given below:
The Stored Procedure is running fine in MySQL Querybrowser but when I call from application the following error is thrown:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 2' at line 1