topic Re: Problem converting from Date to BigDecimal in Talend Studio

Problem converting from Date to BigDecimal

Anonymous — Wed, 04 Sep 2013 09:39:15 GMT

Hello.
I have an excel file with a Date column with pattern "dd/MM/yyyy" and I want to store that value in an oracle table but in number(6) format.
For example, in my excel file I have "11/10/2013" and I want to store it in oracle like 201310
What I do is tFileInputExcel_1 ---> tMap_1 ---> tConvertType_1 ---> tOracleOutput_1
The datatypes in each component are:
tFileInputExcel : Field Fecha_Exp, type Date, Date Pattern "dd/MM/yyyy"
tMap : in the output field I have this: TalendDate.formatDate("yyyyMM",row1.Fecha_Exp) to a output field type String
tConvertType : Autocast, in the input schema the field is a string, in the output schema the field is a BigDecimal
tOracleOutput : the final datatype of the destination field is BigDecimal
It doesn't work, the error is this:
Exception in component tMap_1
java.lang.NullPointerException
at java.util.Calendar.setTime(Unknown Source)
at java.text.SimpleDateFormat.format(Unknown Source)
at java.text.SimpleDateFormat.format(Unknown Source)
at java.text.DateFormat.format(Unknown Source)
at routines.TalendDate.formatDate(TalendDate.java:136)
at coste_distribucion.carga_r_0_1.carga_r.tFileInputExcel_1Process(carga_r.java:1505)
at coste_distribucion.carga_r_0_1.carga_r.runJobInTOS(carga_r.java:2018)
at coste_distribucion.carga_r_0_1.carga_r.main(carga_r.java:1886)

Any help? Thanks in advance.

Re: Problem converting from Date to BigDecimal

Anonymous — Wed, 04 Sep 2013 10:10:27 GMT

Hi,
There is "java.lang.NullPointerException" error in tMap, would you mind uploading the tMap editor screenshot into forum so that we can get the current mapped row structure.
Best regards
Sabrina

Re: Problem converting from Date to BigDecimal

Anonymous — Wed, 04 Sep 2013 10:25:37 GMT

Here it is

Re: Problem converting from Date to BigDecimal

Anonymous — Wed, 04 Sep 2013 11:59:11 GMT

Hi,
The method "TalendDate.formatDate(String pattern, java.util.Date date)" Formats a Date into a date/time string not Date.(I suspect which makes java.lang.NullPointerException )
In you case, you want to get a BigDecimal.
Please try this expression:

new BigDecimal (TalendDate.formatDate("yyyyMM",row1.date))

See my screenshots for details
Best regards
Sabrina

Re: Problem converting from Date to BigDecimal

Anonymous — Thu, 05 Sep 2013 06:25:25 GMT

Hi,
Any update for your issue? Feel free post your issue on forum.
Best regards
Sabrina