topic Re: Copy Table from db oracle to db mysql in Talend Studio

topic Re: Copy Table from db oracle to db mysql in Talend Studio https://community.qlik.com/t5/Talend-Studio/Copy-Table-from-db-oracle-to-db-mysql/m-p/2304107#M75915 <P><A href="https://community.qlik.com/s/profile/0053p000007LOQhAAO">@trk_54</A>,can you post your design and the configuration of <SPAN>tMysqlOutput_1?</SPAN></P> Thu, 21 Jun 2018 09:55:04 GMT manodwhb 2018-06-21T09:55:04Z Copy Table from db oracle to db mysql https://community.qlik.com/t5/Talend-Studio/Copy-Table-from-db-oracle-to-db-mysql/m-p/2304104#M75912 <P>hi everyone </P><P>what sort of component do I have to use to do that ? </P> Sat, 16 Nov 2024 08:03:46 GMT https://community.qlik.com/t5/Talend-Studio/Copy-Table-from-db-oracle-to-db-mysql/m-p/2304104#M75912 Anonymous 2024-11-16T08:03:46Z Re: Copy Table from db oracle to db mysql https://community.qlik.com/t5/Talend-Studio/Copy-Table-from-db-oracle-to-db-mysql/m-p/2304105#M75913 Use below way.<BR /><BR />tOracleInput main to tMsqlOutput Wed, 20 Jun 2018 16:06:27 GMT https://community.qlik.com/t5/Talend-Studio/Copy-Table-from-db-oracle-to-db-mysql/m-p/2304105#M75913 manodwhb 2018-06-20T16:06:27Z Re: Copy Table from db oracle to db mysql https://community.qlik.com/t5/Talend-Studio/Copy-Table-from-db-oracle-to-db-mysql/m-p/2304106#M75914 <P><SPAN>hi </SPAN></P><P><SPAN>thank you for quick answer but I got this message error </SPAN></P><P> </P><P><SPAN>Démarrage du job mat a 14:23 20/06/2018.</SPAN></P><P><SPAN>[statistics] connecting to socket on port 3483</SPAN></P><P><SPAN>[statistics] connected</SPAN></P><P><SPAN>Exception in thread "main" java.lang.Error: Unresolved compilation problems:</SPAN></P><P><SPAN>   pstmt_tMysqlOutput_1 cannot be resolved</SPAN></P><P><SPAN>   batchSizeCounter_tMysqlOutput_1 cannot be resolved to a variable</SPAN></P><P><SPAN>   batchSize_tMysqlOutput_1 cannot be resolved to a variable</SPAN></P><P><SPAN>   batchSizeCounter_tMysqlOutput_1 cannot be resolved to a variable</SPAN></P><P><SPAN>   pstmt_tMysqlOutput_1 cannot be resolved</SPAN></P><P><SPAN>   batchSizeCounter_tMysqlOutput_1 cannot be resolved to a variable</SPAN></P><P><SPAN>   pstmt_tMysqlOutput_1 cannot be resolved</SPAN></P><P><SPAN>   batchSizeCounter_tMysqlOutput_1 cannot be resolved to a variable</SPAN></P><P><SPAN>   pstmt_tMysqlOutput_1 cannot be resolved</SPAN></P><P><SPAN>   batchSizeCounter_tMysqlOutput_1 cannot be resolved to a variable</SPAN></P><P><SPAN>   pstmt_tMysqlOutput_1 cannot be resolved to a variable</SPAN></P><P><SPAN>   pstmt_tMysqlOutput_1 cannot be resolved</SPAN></P><P> </P><P><SPAN>   at hr.mat_0_1.mat.tOracleInput_1Process(mat.java:796)</SPAN></P><P><SPAN>   at hr.mat_0_1.mat.runJobInTOS(mat.java:1270)</SPAN></P><P><SPAN>   at hr.mat_0_1.mat.main(mat.java:1127)</SPAN></P><P><SPAN>Job mat terminé à 14:23 20/06/2018. [Code sortie=0]</SPAN></P><P><BR /><BR /></P> Thu, 21 Jun 2018 09:09:58 GMT https://community.qlik.com/t5/Talend-Studio/Copy-Table-from-db-oracle-to-db-mysql/m-p/2304106#M75914 Anonymous 2018-06-21T09:09:58Z Re: Copy Table from db oracle to db mysql https://community.qlik.com/t5/Talend-Studio/Copy-Table-from-db-oracle-to-db-mysql/m-p/2304107#M75915 <P><A href="https://community.qlik.com/s/profile/0053p000007LOQhAAO">@trk_54</A>,can you post your design and the configuration of <SPAN>tMysqlOutput_1?</SPAN></P> Thu, 21 Jun 2018 09:55:04 GMT https://community.qlik.com/t5/Talend-Studio/Copy-Table-from-db-oracle-to-db-mysql/m-p/2304107#M75915 manodwhb 2018-06-21T09:55:04Z Re: Copy Table from db oracle to db mysql https://community.qlik.com/t5/Talend-Studio/Copy-Table-from-db-oracle-to-db-mysql/m-p/2304108#M75916 <P>here it is thanks </P><BR /><A href="https://community.qlik.com/legacyfs/online/tlnd_dw_files/0683p000009Lt1e">Sans titre.png</A> Thu, 21 Jun 2018 10:10:45 GMT https://community.qlik.com/t5/Talend-Studio/Copy-Table-from-db-oracle-to-db-mysql/m-p/2304108#M75916 Anonymous 2018-06-21T10:10:45Z Re: Copy Table from db oracle to db mysql https://community.qlik.com/t5/Talend-Studio/Copy-Table-from-db-oracle-to-db-mysql/m-p/2304109#M75917 <P>Hello,</P> <P>When you get some compile errors, please check your "Code" tab in your job. There will be your compile error highlighted in red line.</P> <P>Is there any missing double quote between your input parameter of tMySqlOutput?</P> <P>Best regards</P> <P>Sabrina</P> Fri, 22 Jun 2018 09:06:56 GMT https://community.qlik.com/t5/Talend-Studio/Copy-Table-from-db-oracle-to-db-mysql/m-p/2304109#M75917 Anonymous 2018-06-22T09:06:56Z Re: Copy Table from db oracle to db mysql https://community.qlik.com/t5/Talend-Studio/Copy-Table-from-db-oracle-to-db-mysql/m-p/2304110#M75918 <P>Hello Sabrina,</P><P> </P><P>I ve checked the code but I don't know where is the mistake and where do I have to put the double quote </P><P>I ve screen shot some error written in the code </P><P>could you pls check and help me on that case ? </P><P>tanks a lot </P><BR /><A href="https://community.qlik.com/legacyfs/online/tlnd_dw_files/0683p000009Lt7Z">Sans titre.png</A> Fri, 22 Jun 2018 10:17:34 GMT https://community.qlik.com/t5/Talend-Studio/Copy-Table-from-db-oracle-to-db-mysql/m-p/2304110#M75918 Anonymous 2018-06-22T10:17:34Z