tMySqlSP returns com.mysql.jdbc.JDBC4ResultSet@13deb50e

[Anonymous]

calling tMySqlSP gives the above output in newColumn.

Sproc:

CREATE DEFINER=`root`@`localhost` PROCEDURE `my_proc`()
begin
declare a int default 10;
select a;
end

Talend Job:

Output:

.--------------------------------------.
|              tLogRow_1               |
|=------------------------------------=|
|newColumn                             |
|=------------------------------------=|
|com.mysql.jdbc.JDBC4ResultSet@13deb50e|
'--------------------------------------'

I am trying out the component and want to display the value of `a`. (The sproc works fine in MySQL)

Please help!

[Anonymous]

Hello,

The Input parameters is to be returned as a set of values, rather than single value when you choose RECORDSET type.

Best regards

Sabrina