Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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:

0683p000009LyCi.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!

Labels (3)
1 Reply
Anonymous
Not applicable
Author

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