Hello , I have an insert process that I do with Tmap . one of my TmysqlOuput has an auto generated key that I want to recuperate in one field of the other TmysqlOuput Thanks
hello , I'm very sorry of the disturbance , it's my first experience with Talend . But when I set the "Position" to "Replace it's generate an error like : Cannot add or update a child row: a foreign key constraint fails (`datadb`.`filtercriteriarepositoryelement`, CONSTRAINT `FK_filterCriteriaId` FOREIGN KEY (`filterCriteriaId`) REFERENCES `filtercriteria` (`filterCriteriaId`) ON DELETE CASCADE ON UPDATE NO AC)
That's an MySQL error and I don't use MySQL but it looks like it's suggesting the FK is invalid. Did you follow my other instructions: make sure both tMysqlOutput components share a connection and uncheck "Extend Insert"?
Test if the filterCriteriaId is being retrieved correctly by replacing your tMysqlOutput with tFlowToIterate -> tMysqlInput (also sharing a connection; "select last_insert_id()") --> tLogRow.
bonjour
je suis debutant en talend et je voudrais créee une table a partir de talend avec une clé etrangere
mon probleme est que je sais pas comment specifier la contrainte de clé etrangere a partir de tmap
pourriez vous m'aider ???
merci
