topic Re: Null Pointer Exception BigDecimal in Talend Studio

Null Pointer Exception BigDecimal

Anonymous — Tue, 28 Nov 2017 14:16:58 GMT

Hey there,

I want to use this here:

(row5.SUMJHR ! = null ? row5.SUMJHR.toPlainString() : row5.SUMJHR)

talend gets me the error: "Type mismatch: cannot convert from Object&Serialzable&Comparable<?> to String"

Any Idea? The input row is BigDecimal.

Thanks a lot!

Re: Null Pointer Exception BigDecimal

Anonymous — Tue, 28 Nov 2017 14:50:19 GMT

You need to give me more info. For example, what is the field type that this is setting. I am assuming it is String. However, a quick solution might just be this....

(row5.SUMJHR ! = null ? row5.SUMJHR.toPlainString() : null)

Re: Null Pointer Exception BigDecimal

Anonymous — Tue, 28 Nov 2017 14:59:53 GMT

(row5.SUMJHR ! = null ? row5.SUMJHR.toPlainString() : row5.SUMJHR)

i think your expression is wrong. Use this:

(row5.SUMJHR ! = null)? row5.SUMJHR.toPlainString() : row5.SUMJHR

Be sure that your output is a String type

SGV

Re: Null Pointer Exception BigDecimal

Anonymous — Tue, 28 Nov 2017 15:26:55 GMT

@sgv there is no difference between those two expressions. The brackets do nothing

Re: Null Pointer Exception BigDecimal

Anonymous — Tue, 28 Nov 2017 15:34:55 GMT

I got the solution:

row5.SUMJHR == null ? null : row5.SUMJHR.toPlainString()

Re: Null Pointer Exception BigDecimal

Anonymous — Tue, 28 Nov 2017 15:35:20 GMT

I just tested ! You're right 😃

Re: Null Pointer Exception BigDecimal

Anonymous — Tue, 28 Nov 2017 16:20:33 GMT

That is what I suggested

Re: Null Pointer Exception BigDecimal

Anonymous — Wed, 29 Nov 2017 07:15:38 GMT

Hello,

Please mark solution as accepted if it is OK with you question.

Best regard

Sabrina