https://community.qlik.com/t5/Talend-Studio/Need-help-with-tmysqloutput-component/m-p/2305989#M77568 <P>omg. Many thx. I looked everywhere but this !&nbsp;</P> Thu, 21 Jun 2018 09:07:42 GMT Anonymous 2018-06-21T09:07:42Z https://community.qlik.com/t5/Talend-Studio/Need-help-with-tmysqloutput-component/m-p/2305987#M77566 <P>Hi everyone,&nbsp;<BR />I have an issue with the tmysqloutput component while trying to perform an update on my table.<BR />No errors appears but no upate are done (unfair).<BR />I tried my best but now I'm calling for a little help from the community.<BR />So if someone could have a look to my problem...<BR />Now the rock :<BR />I have a "bpsupplier" table with many fields. I only want to update a date field.<BR />The script run well without any error, but I don't understand why the update isn't done in the MySQL database.</P> <P>&nbsp;</P> <P>&nbsp;<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture1.JPG" style="width: 323px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Ly3j.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132051i6B86AF9B3D8192C8/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Ly3j.jpg" alt="0683p000009Ly3j.jpg" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture2.JPG" style="width: 369px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lxui.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/146045i5BD161586A442732/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lxui.jpg" alt="0683p000009Lxui.jpg" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture3.JPG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lxzx.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134592i7FA0E0F3306F643F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lxzx.jpg" alt="0683p000009Lxzx.jpg" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture4.JPG" style="width: 773px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Ly3y.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150217iCA49E7AB75479853/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Ly3y.jpg" alt="0683p000009Ly3y.jpg" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture5.JPG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Ly48.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154916i7F6457988C19573A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Ly48.jpg" alt="0683p000009Ly48.jpg" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture6.JPG" style="width: 992px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Ly4N.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/147032i430FAFB9906470F7/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Ly4N.jpg" alt="0683p000009Ly4N.jpg" /></span></SPAN></P> Sat, 16 Nov 2024 08:03:24 GMT https://community.qlik.com/t5/Talend-Studio/Need-help-with-tmysqloutput-component/m-p/2305987#M77566 Anonymous 2024-11-16T08:03:24Z https://community.qlik.com/t5/Talend-Studio/Need-help-with-tmysqloutput-component/m-p/2305988#M77567 <P>Have you forgotten to check "Auto Commit" in advanced settings of your tMysqlConnection&nbsp;?</P> Thu, 21 Jun 2018 08:59:26 GMT https://community.qlik.com/t5/Talend-Studio/Need-help-with-tmysqloutput-component/m-p/2305988#M77567 navds 2018-06-21T08:59:26Z https://community.qlik.com/t5/Talend-Studio/Need-help-with-tmysqloutput-component/m-p/2305989#M77568 <P>omg. Many thx. I looked everywhere but this !&nbsp;</P> Thu, 21 Jun 2018 09:07:42 GMT https://community.qlik.com/t5/Talend-Studio/Need-help-with-tmysqloutput-component/m-p/2305989#M77568 Anonymous 2018-06-21T09:07:42Z https://community.qlik.com/t5/Talend-Studio/Need-help-with-tmysqloutput-component/m-p/2305990#M77569 <P>are you in auto commit mode?</P> Thu, 21 Jun 2018 09:14:50 GMT https://community.qlik.com/t5/Talend-Studio/Need-help-with-tmysqloutput-component/m-p/2305990#M77569 fdenis 2018-06-21T09:14:50Z