topic Re: BatchSizeCounter and pstmt MysqlOutput ERROR in Talend Studio

BatchSizeCounter and pstmt MysqlOutput ERROR

Anonymous — Sat, 16 Nov 2024 08:03:39 GMT

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

Re: BatchSizeCounter and pstmt MysqlOutput ERROR

Anonymous — Mon, 25 Jun 2018 09:47:40 GMT

Hello,

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

Best regards

Sabrina

Re: BatchSizeCounter and pstmt MysqlOutput ERROR

Anonymous — Tue, 26 Jun 2018 09:25:20 GMT

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

where does it come from ?

thanks for helping

Re: BatchSizeCounter and pstmt MysqlOutput ERROR

Anonymous — Wed, 27 Jun 2018 16:00:07 GMT

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

Re: BatchSizeCounter and pstmt MysqlOutput ERROR

Anonymous — Thu, 28 Jun 2018 08:31:38 GMT

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

Re: BatchSizeCounter and pstmt MysqlOutput ERROR

Anonymous — Thu, 28 Jun 2018 09:06:23 GMT

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

Re: BatchSizeCounter and pstmt MysqlOutput ERROR

Anonymous — Thu, 28 Jun 2018 09:22:37 GMT

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

Re: BatchSizeCounter and pstmt MysqlOutput ERROR

Anonymous — Thu, 28 Jun 2018 10:13:17 GMT

Hello,

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

Best regards

Sabrina

Re: BatchSizeCounter and pstmt MysqlOutput ERROR

Anonymous — Thu, 28 Jun 2018 10:17:56 GMT

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

Re: BatchSizeCounter and pstmt MysqlOutput ERROR

Anonymous — Thu, 28 Jun 2018 10:34:31 GMT

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

Re: BatchSizeCounter and pstmt MysqlOutput ERROR

Anonymous — Thu, 28 Jun 2018 10:37:08 GMT

Hello,

Additionally, could you please follow up this online document about:TalendHelpCenter:Retrieving table schemas to retrieve table schemas from the database connection you have set up.

Best regards

Sabrina

Re: BatchSizeCounter and pstmt MysqlOutput ERROR

Anonymous — Thu, 28 Jun 2018 13:29:23 GMT

thank you for helping Sabrina

Re: BatchSizeCounter and pstmt MysqlOutput ERROR

Anonymous — Fri, 29 Jun 2018 03:40:26 GMT

Hello,

Great it helps. Feel free to post your issue here.

Best regards

Sabrina