guarantee fields order in a mongodb documents using mongodb java driver

Question

Using MongoDB driver 4.1.0 (and quarkus 1.1.1), I have an entity with a composite _id:

@BsonId
@JsonProperty("_id")
private CompositeId id = new CompositeId();

@Data
@AllArgsConstructor
@NoArgsConstructor
public static class CompositeId {
    @BsonProperty("b")
    private int b;
    @BsonProperty("a")
    private String a;
}

(where a is actually an ObjectId hex string)

After saving the entity, the _id fields are preserved in an alphabetic order:

"_id" : {
    "a" : "61a480509da3560292eb1ab5",
    "b" : 1234
},

Later, the same logical entity is upserted elsewhere using pymongo:

collection.update_one({'_id': id}, {'$set': ...

The id in the query document is constructed with python OrderedDict, with b as first in order, and a as second.

So I end up with two identical documents in collection, differ only in _id fields order:

{
    "_id" : {
        "a" : "61a480509da3560292eb1ab5",
        "b" : 1234
    },
    // rest of identical fields for Java inserted document
}
{
    "_id" : {
        "b" : 1234,
        "a" : "61a480509da3560292eb1ab5"
    },
    // rest of identical fields for Python upserted document
}

So, my question is, is there a way to configure the Java driver to preserve the order of fields in document (something such as @JsonPropertyOrder) or less realistically, using quarkus/panache configuration?

Ori Dar · Accepted Answer · 2021-12-01 15:58:23Z

0

Constructing a Bson document did the trick:

Document id = new Document();
id.append("b", 1234);
id.append("a",  new ObjectId().toHexString());
Document entity = new Document("_id", id);
...

answered Dec 1, 2021 at 15:58

Ori Dar

19.1k5 gold badges61 silver badges76 bronze badges

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

Collectives™ on Stack Overflow

guarantee fields order in a mongodb documents using mongodb java driver

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