Copy Table from db oracle to db mysql

Five Stars

Copy Table from db oracle to db mysql

hi everyone 

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

Thirteen Stars

Re: Copy Table from db oracle to db mysql

Use below way.

tOracleInput main to tMsqlOutput
Manohar B
Five Stars

Re: Copy Table from db oracle to db mysql

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]



Thirteen Stars

Re: Copy Table from db oracle to db mysql

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

Manohar B
Five Stars

Re: Copy Table from db oracle to db mysql

here it is thanks 

Moderator

Re: Copy Table from db oracle to db mysql

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Copy Table from db oracle to db mysql

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