报异常could not execute native bulk manipulation query时,
后台给出错误信息:
Hibernate:
{Call backupOperateDatas(?,?,?,?,?,?)}
2013-03-12 10:36:38,468[org.hibernate.util.JDBCExceptionReporter]-[ERROR] The user specified as a definer ('root'@'%') does not exist
于是回头查看了一下存储过程的DDL语句
说明是权限问题,授权 给 root 所有sql 权限
mysql> grant all privileges on *.* to root@"%" identified by ".";
Query OK, 0 rows affected (0.00 sec)
授权后,hibernate执行存储过程不再报错。 权限参考网络资源http://hi.baidu.com/liyanqin2288/item/5de086da8c94ef3348e1dd59