This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates 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