topic Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string in Talend Studio

[resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

slim1501 — Sat, 16 Nov 2024 11:23:13 GMT

Hello,
I have a job that allows you to extract data from Excel and SQL Table to store in a SQL server database.
I did the transformation fields String float.
But I do not understand why I have this error:

Exception in component tMap_2
 java.lang.NumberFormatException: For input string: "0,0506609517898527"
 Has sun.misc.FloatingDecimal.readJavaFormatString (Unknown Source)
 Has java.lang.Float.parseFloat (Unknown Source)
 Has bdd_budget_icp.bud_0_1.Bud.tFileInputDelimited_1Process (Bud.java:2332)
 Has bdd_budget_icp.bud_0_1.Bud.runJobInTOS (Bud.java:4470)
 Has bdd_budget_icp.bud_0_1.Bud.main (Bud.java:4291)
  disconnected

Please find enclosed my tmap and my Job.
What is the problem please? and how to solve it?
Regards

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

Anonymous — Tue, 16 Dec 2014 03:46:32 GMT

Hi slim1501,

What's your input source data type? How did you set your tMap? Did you set length in schema setting? Could you please upload your tmap editor screenshot into forum?
Best regards
Sabrina

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

Anonymous — Tue, 16 Dec 2014 07:54:12 GMT

If you replace coma to dot then it will work. see the below statement.

new BigDecimal("0,0506609517898527".replace(",","."))

or you can use below methods to convert it.

String text = "1,234567";
NumberFormat nf_in = NumberFormat.getNumberInstance(Locale.GERMANY);
double val = nf_in.parse(text).doubleValue();
NumberFormat nf_out = NumberFormat.getNumberInstance(Locale.UK);
nf_out.setMaximumFractionDigits(3);
String output = nf_out.format(val);

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

slim1501 — Tue, 16 Dec 2014 10:23:35 GMT

hello,
My data source is a file (.csv). type columns String.
I set the size to 255 for each column.
enclosed my print-screen.
I tried with Double too, but it does not work
like this:

Relational.ISNULL (fromMainFlow.CST_PROD_KG) == true? null: Double.parseDouble (fromMainFlow.CST_PROD_KG)

Exception in component tMap_2
java.lang.NumberFormatException: For input string: "0,05066095178985277"
    at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source)
    at java.lang.Double.parseDouble(Unknown Source)
    at bdd_budget_icp.bud_0_1.Bud.tFileInputDelimited_1Process(Bud.java:2345)
    at bdd_budget_icp.bud_0_1.Bud.runJobInTOS(Bud.java:4482)
    at bdd_budget_icp.bud_0_1.Bud.main(Bud.java:4303)

Yours

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

Anonymous — Tue, 16 Dec 2014 11:14:31 GMT

can you try the solution i provided. I am sure that will work for you.

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

slim1501 — Tue, 16 Dec 2014 11:31:45 GMT

First of all, thank you for your help.
I do not know where to put your code !! Is it in the Tmap (in each destination field)?

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

Anonymous — Tue, 16 Dec 2014 11:37:07 GMT

My bad, I should explain it in better way.
so first line of code you can implement it directly in tMap.

new BigDecimal(row1.yourcolumnName.replace(",","."))

but for second solution, you have to create routine and add static method which return BigDecimal value, then write down mention code that can be work.

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

slim1501 — Tue, 16 Dec 2014 11:49:40 GMT

sorry, I'm a beginner, I could not do it (routine) !!

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

Anonymous — Tue, 16 Dec 2014 12:08:57 GMT

Below link will help you to do that, but have you tried first solution? and what is the output?
Creating a user routine and call it in a Job

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

slim1501 — Tue, 16 Dec 2014 12:12:54 GMT

I got this error:

Exception in component tMap_2
 java.lang.NumberFormatException
 Has java.math.BigDecimal. <init> (Unknown Source)
 Has java.math.BigDecimal. <init> (Unknown Source)
 Has bdd_budget_icp.bud_0_1.Bud.tFileInputDelimited_1Process (Bud.java:3429)
 Has bdd_budget_icp.bud_0_1.Bud.runJobInTOS (Bud.java:4067)
 Has bdd_budget_icp.bud_0_1.Bud.main (Bud.java:3888)

Do I need to change something my database SQL server data (output)?
CREATE TABLE BUDGET_CA
(current_file varchar(255) PRIMARY KEY NOT NULL,
Date_Bud Date,
code_CLI varchar(255),
NAT_CODE varchar(255),
code_article varchar(255),
ACTION_BUD2014 varchar(255),
Zone_Geo varchar(255),
Tx_RFA DECIMAL(19,5) ,
CST_PROD_KG DECIMAL(19,5),
CST_LOG_KG DECIMAL(19,5) ,
Kilo_BU DECIMAL(19,5) ,
CA_BUD DECIMAL(19,5) ,
CMA_BUD DECIMAL(19,5) ,
Cpt_Comptbl_F varchar(255),
Code_Analytiques varchar(255)
);
Here join a screen-prints of my CSV file

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

Anonymous — Tue, 16 Dec 2014 12:33:28 GMT

what coma denotes in all the fields? is it a thousand separator or a decimal point?

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

slim1501 — Tue, 16 Dec 2014 14:05:56 GMT

It's a decimal point

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

Anonymous — Tue, 16 Dec 2014 14:12:48 GMT

then below statement should work, use below statement for all the columns which has numeric data and you want to convert it to big decimal.

new BigDecimal(row1.tx_rfa.replace(",","."))

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

slim1501 — Tue, 16 Dec 2014 14:37:00 GMT

I'll try,
But,Typing my database should I leave it as it is?

CREATE TABLE BUDGET_CA
 (CURRENT_FILE varchar (255) NOT NULL PRIMARY KEY,
 Date_Bud Date,
 code_CLI varchar (255),
 NAT_CODE varchar (255),
 code_article varchar (255),
 ACTION_BUD2014 varchar (255),
 Zone_Geo varchar (255),
 Tx_RFA DECIMAL (19,5)
 CST_PROD_KG DECIMAL (19,5)
 CST_LOG_KG DECIMAL (19,5)
 Kilo_BU DECIMAL (19,5)
 CA_BUD DECIMAL (19,5)
 CMA_BUD DECIMAL (19,5)
 Cpt_Comptbl_F varchar (255),
 Code_Analytiques varchar (255)
 );

Thank you for your help.

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

slim1501 — Tue, 16 Dec 2014 14:46:39 GMT

I tried it, it did not work, I got this error:

Exception in component tMap_2
 java.lang.NumberFormatException
 Has java.math.BigDecimal. <init> (Unknown Source)
 Has java.math.BigDecimal. <init> (Unknown Source)
 Has bdd_budget_icp.bud_0_1.Bud.tFileInputDelimited_1Process (Bud.java:2296)
 Has bdd_budget_icp.bud_0_1.Bud.runJobInTOS (Bud.java:4089)
 Has bdd_budget_icp.bud_0_1.Bud.main (Bud.java:3910)

I do not understand why it does not work !!!!!

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

Anonymous — Wed, 17 Dec 2014 07:08:55 GMT

can you show me your input component schema and tmap output schema.

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

slim1501 — Wed, 17 Dec 2014 10:09:30 GMT

The problem was the comma. I resolved; in each column that I want to convert I do this:

fromMainFlow.Tx_RFA! = null && fromMainFlow.Tx_RFA.trim ().length ()> 0? 
BigDecimal.valueOf (Double.valueOf (fromMainFlow.Tx_RFA.replaceAll (",", "."))): null

Thank you all for your help.
See you soon.
have a nice day

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

Anonymous — Wed, 12 Dec 2018 10:33:21 GMT

Hi ,

While trying and loading the data in output database, i am getting below error:

Couldn't parse value for column 'CID' in 'row1', value is '"5"'. Details: java.lang.NumberFormatException: For input string: ""5""
Couldn't parse value for column 'CID' in 'row1', value is '"48"'. Details: java.lang.NumberFormatException: For input string: ""48""

PFA screenshots of tMap

Please suggest the needful

tMap_Screenshot.png

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

Anonymous — Wed, 12 Dec 2018 10:43:41 GMT

Please reply me ..its urgent

Re: [resolved] Error in a Tmap : java.lang.NumberFormatException: For input string

Anonymous — Tue, 29 Jan 2019 08:10:49 GMT

Hello,

You are inserting the value "CID" from row1in to the field having data type as integer and it should not consist of character value, like "".

Best regards

Sabrina