how to insert data into mysql database

One Star

how to insert data into mysql database

Hi
My source data is coming form excel form,need to insert tht data into table userslist of mysql database
got the below error,
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
pstmt_tMysqlOutput_1 cannot be resolved
pstmt_tMysqlOutput_1 cannot be resolved
pstmt_tMysqlOutput_1 cannot be resolved
pstmt_tMysqlOutput_1 cannot be resolved
pstmt_tMysqlOutput_1 cannot be resolved
pstmt_tMysqlOutput_1 cannot be resolved
pstmt_tMysqlOutput_1 cannot be resolved
pstmt_tMysqlOutput_1 cannot be resolved
pstmt_tMysqlOutput_1 cannot be resolved
pstmt_tMysqlOutput_1 cannot be resolved
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
batchSize_tMysqlOutput_1 cannot be resolved to a variable
batchSizeCounter_tMysqlOutput_1 cannot be resolved to a variable
pstmt_tMysqlOutput_1 cannot be resolved to a variable
pstmt_tMysqlOutput_1 cannot be resolved

How to resolve this?
pls provide any solution
One Star

Re: how to insert data into mysql database

Check your parameters. Looks like you're missing start/end double quote.
Seven Stars

Re: how to insert data into mysql database

I think I encountered this problem a couple of weeks ago for no apparent reason I could determine at the time. Eventually (after pulling my hair out for 10 minutes) I think I found that re-syncing the schema of the output component got it working again. Good luck.