topic Re: Data type mismatch error: java.utill.date in Talend Studio

Data type mismatch error: java.utill.date

Anonymous — Wed, 28 Mar 2018 04:56:57 GMT

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

Re: Data type mismatch error: java.utill.date

manodwhb — Wed, 28 Mar 2018 05:30:29 GMT

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

Re: Data type mismatch error: java.utill.date

Anonymous — Wed, 28 Mar 2018 06:42:00 GMT

@manodwhb

Thanks for the reply,

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

Re: Data type mismatch error: java.utill.date

manodwhb — Wed, 28 Mar 2018 07:56:59 GMT

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

Re: Data type mismatch error: java.utill.date

Anonymous — Wed, 28 Mar 2018 08:10:55 GMT

@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.

Re: Data type mismatch error: java.utill.date

manodwhb — Wed, 28 Mar 2018 08:23:57 GMT

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

Re: Data type mismatch error: java.utill.date

Anonymous — Wed, 28 Mar 2018 08:40:07 GMT

correct formate of date is observed here toohas this driver got something to do with this is?

Re: Data type mismatch error: java.utill.date

manodwhb — Wed, 28 Mar 2018 09:01:59 GMT

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

Re: Data type mismatch error: java.utill.date

Anonymous — Sat, 31 Mar 2018 01:55:49 GMT

That didnt work either @manodwhb

Re: Data type mismatch error: java.utill.date

Anonymous — Sat, 31 Mar 2018 13:41:23 GMT

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.

Re: Data type mismatch error: java.utill.date

Anonymous — Sat, 31 Mar 2018 19:20:24 GMT

please check the errors in the attached files.

Capture1.JPG
Capture2.JPG
Capture3.JPG

Re: Data type mismatch error: java.utill.date

abhi90 — Sun, 01 Apr 2018 08:34:40 GMT

Then do one thing. use TalendDate.formatDate and ParseDate. Basically will convert from Date to String and ParseDate will convert that String to Date. One thing u check first is printing that Date column in your tlogrow of a Test Job.also check carefully in the Target DB what is the column Format or DataType. This is a Compile Time issue.

Re: Data type mismatch error: java.utill.date

Anonymous — Sun, 01 Apr 2018 21:25:37 GMT

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.

Re: Data type mismatch error: java.utill.date

Anonymous — Sun, 01 Apr 2018 21:38:29 GMT

Thanks @rhall

perfect!!