topic Runtime -mysql exception in Talend Studio

Runtime -mysql exception

Anonymous — Thu, 25 Apr 2013 15:58:59 GMT

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

Re: Runtime -mysql exception

janhess — Thu, 25 Apr 2013 16:20:56 GMT

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

Re: Runtime -mysql exception

Anonymous — Thu, 25 Apr 2013 16:38:49 GMT

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