topic Re: tMysqlRow and tForEach in Talend Studio

tMysqlRow and tForEach

Anonymous — Fri, 27 Apr 2012 02:12:46 GMT

I am trying to join a tForEach to a tMysqlRow, however when I link it with Iterate, I get the error "Iterate cannot be resolved" if I try it with a 'Run If' I get the error "If cannot be resolved". No matter how I try and join the components it seems I get the same error.
Can I not use a tMySqlRow with a Foreach?
Thanks,
Luke

Re: tMysqlRow and tForEach

Anonymous — Fri, 27 Apr 2012 03:51:37 GMT

Hi
Yes, you can link tForEach to tMysqlRow with iterate, for example:
tForEach--iterate--tMysqlRow
Which OS? Which version? Did you try to restart Talend studio?

Best regards
Shong

Re: tMysqlRow and tForEach

Anonymous — Fri, 27 Apr 2012 06:25:52 GMT

I did try restarting Talend. On Windows 7 using integration suite 4.1.2

Re: tMysqlRow and tForEach

Anonymous — Fri, 27 Apr 2012 12:06:47 GMT

If the reason for this is to add multiple queries see this thread I wrote a while ago:
https://community.talend.com/t5/Design-and-Development/cHTTP-and-cMQConnectionFactory-in-one-route/td-p/92598
However I do this a new way now:
if you are using tMySQlconnect then add this in the advanced settings additional JDBC parameters:
allowMultiQueries=true
or on the tMysqlRow in advanced settings itself.
you will then be able to have multiple queries:
"
UPDATE table1 ... ;
UPDATE table2 ... ;
UPDATE table3 ... ;
"
Regards,
Brandon