The error occurred while setting parameters

org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: 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 ” at line 1
### The error may exist in xxxxx.java (best guess)
### The error may involve xxxxx.mode3Total-Inline
### The error occurred while setting parameters
### SQL: {CALL xxxxxx(?,?,?,?)}
### Cause: 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 ” at line 1
; bad SQL grammar []; nested exception is 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 ” at line 1

原因是:存储过程还未完善,但是执行存储过程,在navicat中能看到正确的结果,但是查看执行信息仍然可以看到执行的错误!


29 Clicks !