hibernate执行mysql存储过程报异常could not execute native bulk manipulation query

报异常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