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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Error while importing csv file to mysql database

I have the following setup,
I created a csv file in open talend studio, from this sheme I created a generic scheme and entered the mysql information (varchar, date, lengths). Then I created a job as the csv being an input and the mysql being the output, on the mysql side I atteched the generic scheme. While running the job I get the following error:
Starting job lll at 15:30 14/07/2011.
connecting to socket on port 3949
connected
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
The method getTime() is undefined for the type String
at gmd_import_lars.lll_0_1.lll.tFileInputDelimited_1Process(lll.java:1932)
at gmd_import_lars.lll_0_1.lll.runJobInTOS(lll.java:2297)
at gmd_import_lars.lll_0_1.lll.main(lll.java:2171)
Job lll ended at 15:30 14/07/2011.
Does anyone know if there is a solution for this?
Labels (4)
1 Reply
Anonymous
Not applicable

Hi
There is a complication error in the generated code, open the code tab and you will see which line has error. Where's your screenshot?
Best regards
Shong