NumberFormatException : For input string: "null" [duplicate]

Question

Below is spinet that I am using to make some simple division but it is working for small set of values when I am fetching a large no of data from DB it throws

java.lang.NumberFormatException: : For input string: "null"

List<String> MMRafterDivision = new ArrayList<>();
List<String> ReplaceNull = new ArrayList<>();
List<String> MMRDivisionMultiplier = new ArrayList<>();

public void MMRandMultiplier() {

    MMRafterDivision.add(null);
    MMRafterDivision.add("700");
    MMRafterDivision.add("900");
    ReplaceNull.add("1");
    ReplaceNull.add(null);

    for (int i = 0; i < ReplaceNull.size(); i++) {
        String strMMR = MMRafterDivision.get(i);
        String strMultiplier = ReplaceNull.get(i);
        if (strMMR == null && strMultiplier == null) {
            MMRDivisionMultiplier.add("null");
        }
        else if(strMMR == null && strMultiplier != null){
            MMRDivisionMultiplier.add("null");
        }
        else if(strMMR != null && strMultiplier == null) {
            MMRDivisionMultiplier.add(strMMR);
        }
        else{
            String result = String.valueOf(Double.valueOf(strMMR) / Double.valueOf(strMultiplier));
            MMRDivisionMultiplier.add(String.valueOf(result));
        }
    }
    System.out.println("MMR&MUL:"+MMRDivisionMultiplier);
}

Please help to rectify my mistake.

@Adya I have corrected the things and it works fine for small set of values, can you take a look and tell me why it does not work when I am fetching large set of data from DB — Lavish Khetan
– Lavish Khetan, Commented May 14, 2018 at 11:53

xingbin · Accepted Answer · 2018-05-14 10:59:50Z

2

You added a null to the List:

ReplaceNull.add(null);

Then retrieved it and parsed it by:

Integer.parseInt(strMultiplier)

Since null is not a parsable int, NumberFormatException was thrown.

answered May 14, 2018 at 10:59

xingbin

28.4k12 gold badges62 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Lavish Khetan Over a year ago

I have corrected the code, can you please take a look now, since i have to fetch the data from the DB in real time and there are null, so i just cannot ignore it,I have to do this with null

Collectives™ on Stack Overflow

NumberFormatException : For input string: "null" [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related