Talend community forum / tMysqlRow and tForEach

lshannon · 2012-04-27 03:12:46

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

shong · 2012-04-27 04:51:37

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

lshannon · 2012-04-27 07:25:52

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

brandon_stubbs93 · 2012-04-27 13:06:47

If the reason for this is to add multiple queries see this thread I wrote a while ago:
http://www.talendforge.org/forum/viewto … 061#p56061

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

Announcement

Unanswered posts

#1 2012-04-27 03:12:46

tMysqlRow and tForEach

#2 2012-04-27 04:51:37

Re: tMysqlRow and tForEach

#3 2012-04-27 07:25:52

Re: tMysqlRow and tForEach

#4 2012-04-27 13:06:47

Re: tMysqlRow and tForEach

Board footer