Error comming while connect with stored procedure in mysql
843785Dec 29 2008 — edited Dec 29 2008While I'm trying to connect with stored procedure in mysql via my program, the following compile time errors are comming. For that i have given permission to that stored procedure like
grant execute on procedure test_new.SEL_PRO to root@localhost;
test_new--------->DB Name
SEL_PRO-------->Procedure name
Stll now the same error is comming
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.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:1593)
at com.mysql.jdbc.DatabaseMetaData.getProcedureOrFunctionColumns(DatabaseMetaData.java:4120)
at com.mysql.jdbc.DatabaseMetaData.getProcedureColumns(DatabaseMetaData.java:4057)
at com.mysql.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:809)
at com.mysql.jdbc.CallableStatement.<init>(CallableStatement.java:609)
at com.mysql.jdbc.CallableStatement.getInstance(CallableStatement.java:502)
at com.mysql.jdbc.ConnectionImpl.parseCallableStatement(ConnectionImpl.java:3881)
at com.mysql.jdbc.ConnectionImpl.prepareCall(ConnectionImpl.java:3965)
at com.mysql.jdbc.ConnectionImpl.prepareCall(ConnectionImpl.java:3939)
at jdbcdemo.main(jdbcdemo.java:25)