How to get integer value from mongodb bson document using java?

Question

I am trying to retrieve an integer from bson document using the following code:

MongoCursor<Document> cursor = collection.find().iterator();
while (cursor.hasNext()) {
    Document rowDoc = cursor.next();
    int myNum = rowDoc.getInteger("number");
}

then I got this exception:

java.lang.ClassCastException: java.lang.Double cannot be cast to java.lang.Integer

As I thought number is double my change was:

double myNum = rowDoc.getDouble("number");

But this time I got:

java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Double

I've checked the value type in mongo shell returning number. So what am I doing wrong?

Maybe you have mixed types. Try ((Number)rowDoc.get("number")).intValue() — shmosel
– shmosel, Commented Mar 14, 2017 at 22:33
@shmosel : public <T> T get("number", Number.class) is more appropriate. — user5741800
– user5741800, Commented Mar 14, 2017 at 22:43
@shmosel: It solved my problem. Thanks a lot. I would still appreciate some detailed explanation. — SharifS
– SharifS, Commented Mar 14, 2017 at 22:49
Just a thought. Why are you storing them as double and integer if you just care about int value ? Would it help to update the data to just include integer ? Then int myNum = rowDoc.getInteger("number"); will work as expected. — s7vr
– s7vr, Commented Mar 14, 2017 at 23:00

geisterfurz007 · Accepted Answer · 2020-01-13 09:55:08Z

3

Try int myNum = rowDoc.getInteger("number").getValue();

edited Jan 13, 2020 at 9:55

geisterfurz007

5,9246 gold badges37 silver badges59 bronze badges

answered Jan 13, 2020 at 9:47

Vaibhav

462 bronze badges

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

Collectives™ on Stack Overflow

How to get integer value from mongodb bson document using java?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related