Runtime -mysql exception

One Star

Runtime -mysql exception

Hi All,
I am getting below error while run the Talend job.
Exception in component tMysqlSP_1
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.
Any idea?
Thanks in advance
Chin
One Star

Re: Runtime -mysql exception

User does not have access to metadata required to determine stored procedure parameter types
One Star

Re: Runtime -mysql exception

Hi,
I dont have root access to your MySQL database.I give addition JDBC params =noAccessToProcedureBodies=true property. Is this correct?
After this the following error;
Error;
Exception in component tMysqlSP_1
java.sql.SQLException: No value specified for parameter 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:1851)
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:1775)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:901)
at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:851)

Thanks
Chin