topic Re: cannot convert from Object&Serializable&Comparable<?> to Date in Talend Studio

cannot convert from Object&Serializable&Comparable to Date

Anonymous — Wed, 25 Jan 2017 20:48:45 GMT

Hi,
I am converting two strings into date data types but keeping into an error I do not fully comprehend.
This is my snippet in tMap output into the database:

(row1.Week == null || row1.Week == ("")) ? "" : TalendDate.parseDate("MM/dd/yyyy",row1.Week)

Type mismatch: cannot convert from Object&Serializable&Comparable<?> to Date

Thanks in advance,
CM

Re: cannot convert from Object&Serializable&Comparable to Date

TRF — Thu, 26 Jan 2017 08:19:45 GMT

Hi,
I think it's because TalendDate.parseDate returns a date datatype and the left part of the ternary operator returns a String.
http://stackoverflow.com/questions/25190374/type-mismatch-in-a-conditional-operator-java

Regards,
TRF

Re: cannot convert from Object&Serializable&Comparable to Date

Anonymous — Thu, 26 Jan 2017 14:26:18 GMT

Thanks,
Even when I do

row1.Week == ("") ? "" : TalendDate.parseDate("MM/dd/yyyy",row1.Week)

it still returns the same error. How can I encapsulate the null (blank) and parseDate so the field can be converted to a date type. Any assistance would be appreciated.

Re: cannot convert from Object&Serializable&Comparable to Date

TRF — Thu, 26 Jan 2017 15:46:27 GMT

Try

row1.Week == null || "".equals(row1.Week) ? "" : TalendDate.parseDate("MM/dd/yyyy",row1.Week)

Re: cannot convert from Object&Serializable&Comparable to Date

Anonymous — Thu, 26 Jan 2017 16:50:57 GMT

Thanks again but the error persists on my side. I google-fu the error but since it is Talend oriented could not get SO to show anything.

Re: cannot convert from Object&Serializable&Comparable to Date

vapukov — Thu, 26 Jan 2017 23:54:00 GMT

What source and target columns type in tMap?

for example if row1.Week - text, use not == but row1.week.equals("")
but the best - add full information there, what from left and what from right

Re: cannot convert from Object&Serializable&Comparable to Date

KrupalGharat — Wed, 08 Apr 2020 08:47:57 GMT

Hello @Colleen @TRF @vapukov ,

I am facing the same issue.

When i use (row1.Dat == null || row1.Date.equals(""))?null: (TalendDate.parseDate("yyyy-mm-dd'T'hh:mm:ss.SSS'Z'",row1.Date)) , the I get rid of the error Object&Serializable&Comparable<?> to Date.

But now I am getting Null Pointer Exception when value in row1.Date is null.

Please reply asap.

Thanks in advance.

Re: cannot convert from Object&Serializable&Comparable to Date

Anonymous — Wed, 08 Apr 2020 10:02:04 GMT

@KrupalGharat, can you confirm the NPE is thrown by this expression? Do you have other java code expression? Can you upload a screenshot of tMap?

Regards
Shong

Re: cannot convert from Object&Serializable&Comparable to Date

KrupalGharat — Wed, 08 Apr 2020 10:27:40 GMT

@shong

Yes, the Exception is thrown because of the above mentioned Expression (i.e. (row1.Date == null || row1.Date.equals(""))?null: (TalendDate.parseDate("yyyy-mm-dd'T'hh:mm:ss.SSS'Z'",row1.Date)) ).

Error: Exception in component tMap_1 java.lang.NullPointerException

tMap:

Re: cannot convert from Object&Serializable&Comparable to Date

Anonymous — Wed, 08 Apr 2020 10:44:33 GMT

@KrupalGharat, I have tested your expression and confirmed that this expression will not throw NPE. Please make some testing, remove this expression or column from the output table and run again.

Re: cannot convert from Object&Serializable&Comparable to Date

KrupalGharat — Wed, 08 Apr 2020 11:28:01 GMT

My bad. In the output component, I had not checked the Nullable checkbox.
Talend should be more precise on which component the error exists.
Thank you @shong for your time.