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

Data type mismatch error: java.utill.date

Hi,

Im trying to load data from SQL server db but unable to do so because this below error.

Any thing that would help is appreciated

Thanks

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I *think* I know what it is. Your job is called Date. Your job is essentially a Java class. Change the name of your job and I believe this will fix it.

View solution in original post

13 Replies
manodwhb
Champion II
Champion II

@Aravind_M,could you please check what date format do you have in DB?

Anonymous
Not applicable
Author

@manodwhb 

Thanks for the reply,

I have the format in both the dbs as yyyy-mm-dd 

 

manodwhb
Champion II
Champion II

@Aravind_M,but i see "dd-MM-yyyy' in row1 shema? please check that could be the issue.

Anonymous
Not applicable
Author

@manodwhb 

Oh!! I was just trying out different formats, I could have not changed it while taking the screenshot

I have changed it my job anyways but still the same error persists


@manodwhbwrote:

@Aravind_M,but i see "dd-MM-yyyy' in row1 shema? please check that could be the issue.


 

manodwhb
Champion II
Champion II

@Aravind_M,just extract the data from sql server and write it to tlogrow to check the data how are you getting Talend.

Anonymous
Not applicable
Author

0683p000009LtMg.jpgcorrect formate of date is observed here too0683p000009LtMv.jpghas this driver got something to do with this is?

manodwhb
Champion II
Champion II

since you need to install mssql-jdbc.jar from screenshot,can you install that?

Anonymous
Not applicable
Author

That didnt work either @manodwhb

Anonymous
Not applicable
Author

Don't worry about Date formats unless your database is storing your date as a String. Dates are essentially numbers. Formats are just representations of those numbers. The ONLY time you need to worry about formats is when you are translating from a String to a Date or when you are wanting to represent a Date as text.

You have not given enough information here to see the issue. It is a compile time issue which means your generated code will show where the error is. In the bottom left corner of your workspace, you will see a Code tab. Click on it. It will take a while to generate the Java code for this job. When it completes you will see yellow and red boxes along the right side of the code. You can ignore yellow boxes as warnings (you won't get rid of those and they cause no harm). You need to look for red boxes. They will stop the job compiling AND (this is important) point you towards the actual issue. Click on the red boxes and it will take you to the code that is broken. Take a screen shot of the broken code and post it. That will help us identify this.