magicgod on rails

2008-07-08

在hibernate 中执行存储过程遇到的权限问题

执行存储过程可能会遇到：User does not have access to metadata require
d to determine stored procedure parameter types

以下是解决的方法：http://sql.dzone.com/tips/quick-tip-grating-access-meta-

If you have root access to your MySQL database then you can simply run a query on the database to resolve the problem. What the query will do is give the specified user the needed rights on the mysql.proc table. This takes the form of the following GRANT SQL query:

GRANT [SELECT, INSERT, UPDATE] ON `mysql`.`proc` TO 'myuser'@'myhost';

That's it, after running this query on the database the above exception goes away. If however, you do not have the needed root access to run this query on the database then below is the connection string to use to get around this problem. Very simple, just add &noAccessToProcedureBodies=true to your current connection string and you are done.

String connectionURL = "jdbc:mysql://localhost:3306/mydatabase?user=myuser&password=mypassword&noAccessToProcedureBodies=true"

I sincerely hope this tip will help out someone else. If not, well, then at least I now know where to go the next time I run into this problem