JAVA调用mysql存储过程noAccessToProcedureBodies错误

时间：2017-05-17 09:19:15 收藏：0 阅读：2240

问题：在JAVA中调用MYSQL存储过程遇到以下报错：

java.sql.SQLException: User does not have access to metadata required to determine stored procedure parameter types. If rights can not be granted, configure connection with "noAccessToProcedureBodies=true" to have driver generate parameters that represent INOUT strings irregardless of actual parameter types

解决：需要有存储过程的execute的权限，还需要对mysql.proc具有访问权限。

grant select on mysql.proc to user@host;
flush privileges;

原文：http://www.cnblogs.com/kevinlucky/p/6865720.html