BatchSizeCounter and pstmt MysqlOutput ERROR

[Anonymous]

Hi,

when I launch the job those error appear:

batchSizeCounter_tMySqlOutput cannot be solved

pstmt_tMySqlOutput cannot be solved

what means these error ?

thank you 

[Anonymous]

Hello,

Did you miss any double quote between your input parameter on the component setting of tMySqlOutPut?

Best regards

Sabrina

[Anonymous]

Hi Sabrina, I didn't miss any quotes but I still got the error

where does it come from ? 

thanks for helping

[Anonymous]

Hello,

What's MySql version are you trying to connect? MySql 5? Are you able to load data from a flat file into your MySql DB?

Best regards

Sabrina

[Anonymous]

hi,

I'm using mysql5 and I did this example:

https://help.talend.com/reader/09ej8OQ5bh_~cQtWy~QTbw/uHP_~eLbP2HYIyx0DE4d6g

and it works successfully so that's why I don't now why do I have any problems with java compilation..

thanks for helping 

[Anonymous]

Hello,

Regardless the java compilation error, are you able to load data into your mysql DB? Could you please try to re-start your studio to see if this java compilation error disappear?

Additionally, please check your "Code" tab in your job to see  if there will be your compile error highlighted in red line?

Best regards

Sabrina

[Anonymous]

Thank you for quick answer,

yes I m able to load data from a flat file into mysql Db but not from an another db

I restarted it many time, no change..

here a part of the code, each time the error is [...] cannot be resolved to a variable 

thanks for helping  

[Anonymous]

Hello,

Did you use any t<DB>Connection in your workflow? Your job design is:toracleinput-->tmysqloutput without other component?

Best regards

Sabrina

[Anonymous]

hi,

my job is just tOracleinput --> tMysqloutput 

and when I verify each component they are well connected 

I did not use any t<DB>connection 

[Anonymous]

Hello,

From your component setting screenshot, we know that you are creating the component from the Metadata repository. Are you missing some necessary steps? Such as, retrieving schema from your table?

Did you set any schema in your DB component?

Best regards

Sabrina