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

Anonymous — Thu, 14 Jun 2018 12:59:57 GMT

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!

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

Anonymous — Thu, 28 Jun 2018 09:57:55 GMT

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

topic Re: tMySqlSP returns com.mysql.jdbc.JDBC4ResultSet@13deb50e in Talend Studio

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

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