weblogic启动时报连接mysql错误:configure connection with "noAccessToProcedureBodies=true"
下面是详细错误
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.
解决的方法有两个:
1,授予数据库用户对mysql.proc有select的权限
2, 在连接字符串中加入noAccessToProcedureBodies=true,使连接字符串为 URL:jdbc:mysql://192.168.1.1:3306/testdb?useUnicode=true&characterEncoding=utf-8&useOldAliasMetadataBehavior=true&noAccessToProcedureBodies=true