Copy Table from db oracle to db mysql

[Anonymous]

hi everyone 

what sort of component do I have to use to do that ? 

[manodwhb]

Use below way.

tOracleInput main to tMsqlOutput

[Anonymous]

hi

thank you for quick answer but I got this message error

Démarrage du job mat a 14:23 20/06/2018.

[statistics] connecting to socket on port 3483

[statistics] connected

Exception in thread "main" java.lang.Error: Unresolved compilation problems:

   pstmt_tMysqlOutput_1 cannot be resolved

   batchSizeCounter_tMysqlOutput_1 cannot be resolved to a variable

   batchSize_tMysqlOutput_1 cannot be resolved to a variable

   batchSizeCounter_tMysqlOutput_1 cannot be resolved to a variable

   pstmt_tMysqlOutput_1 cannot be resolved

   batchSizeCounter_tMysqlOutput_1 cannot be resolved to a variable

   pstmt_tMysqlOutput_1 cannot be resolved

   batchSizeCounter_tMysqlOutput_1 cannot be resolved to a variable

   pstmt_tMysqlOutput_1 cannot be resolved

   batchSizeCounter_tMysqlOutput_1 cannot be resolved to a variable

   pstmt_tMysqlOutput_1 cannot be resolved to a variable

   pstmt_tMysqlOutput_1 cannot be resolved

   at hr.mat_0_1.mat.tOracleInput_1Process(mat.java:796)

   at hr.mat_0_1.mat.runJobInTOS(mat.java:1270)

   at hr.mat_0_1.mat.main(mat.java:1127)

Job mat terminé à 14:23 20/06/2018. [Code sortie=0]

[manodwhb]

@trk_54,can you post your design and the configuration of tMysqlOutput_1?

[Anonymous]

here it is thanks 

Sans titre.png

[Anonymous]

Hello,

When you get some compile errors, please check your "Code" tab in your job. There will be your compile error highlighted in red line.

Is there any missing double quote between your input parameter of tMySqlOutput?

Best regards

Sabrina

[Anonymous]

Hello Sabrina,

I ve checked the code but I don't know where is the mistake and where do I have to put the double quote 

I ve screen shot some error written in the code 

could you pls check and help me on that case ? 

tanks a lot 

Sans titre.png