This week's book giveaway is in the Mac OS forum. We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line! See this thread for details.
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