Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (4)
2 Replies
janhess
Creator II
Creator II

Check your parameters. Looks like you're missing start/end double quote.
alevy
Specialist
Specialist

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.