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

Four Stars

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

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:

Screenshot (3).png

 

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!

Moderator

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

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

 

 
 
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.