Auto increment sequence in mongodb using java

Question

Hi I want to auto increment _id in mongodb using java. I am completely new to this. In the document I found the solution like this:

db.counters.insert(
 {
      _id: "userid",
      seq: 0
   }
)


function getNextSequence(name) {
var ret = db.counters.findAndModify(
{
query: { _id: name },
update: { $inc: { seq: 1 } },
new: true
}
);
return ret.seq;
}

db.users.insert(
{
_id: getNextSequence("userid"),
name: "Sarah C."
}
)

Can any one suggest how do I do this using java ? I am completely new to this.

Take a look at stackoverflow.com/questions/20540700/…

Swapnil
– Swapnil

2015-08-18 06:29:21 +00:00
Commented Aug 18, 2015 at 6:29 — Swapnil
– Swapnil, Commented Aug 18, 2015 at 6:29

Neo-coder · Accepted Answer · 2015-08-18 07:37:42Z

13

Using Create an Auto-Incrementing Sequence Field first you should create collection using mongoDB shell and collection should be as :

db.counters.insert(
{
  _id: "userid",
  seq: 0
})

So you get counters collections which contains field like _id,seq, now create getNextSequence function in java and this function having parameter userid as string so getNextSequence function like this :

public static Object getNextSequence(String name) throws Exception{
    MongoClient mongoClient = new MongoClient( "localhost" , 27017 );
    // Now connect to your databases
    DB db = mongoClient.getDB("demo");
    DBCollection collection = db.getCollection("counters");
    BasicDBObject find = new BasicDBObject();
    find.put("_id", name);
    BasicDBObject update = new BasicDBObject();
    update.put("$inc", new BasicDBObject("seq", 1));
    DBObject obj =  collection.findAndModify(find, update);
    return obj.get("seq");

}

The above function return seq count and used this function in main method as like :

public static void main(String[] args) throws Exception {

    MongoClient mongoClient = new MongoClient( "localhost" , 27017 );
    // Now connect to your databases
    DB db = mongoClient.getDB("demo");
    DBCollection collection = db.getCollection("counters");
    BasicDBObject document = new BasicDBObject();

    document.put("_id", getNextSequence("userid"));
    document.put("name","Sarah C.");
    collection.insert(document); // insert first doc

    document.put("_id", getNextSequence("userid"));
    document.put("name", "Bob D.");
    collection.insert(document); // insert second doc
}

Now in counters collection contains three documents which contains name as Sarah C. and Bob D. respectively and one default documents which we inserted manually at first time and it increment seq like this { "_id" : "userid", "seq" : 2 }

answered Aug 18, 2015 at 7:37

Neo-coder

7,8585 gold badges36 silver badges54 bronze badges

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

3 Comments

Yiping Over a year ago

What if one of the put operation fail and the sequence is not used?

Stu_Dent Over a year ago

What about using mlab at this moment?

Stu_Dent Over a year ago

is it still works or got updated since 5 years old?

Tunaki · Accepted Answer · 2016-06-25 13:39:14Z

3

DBCollection collection = database.getCollection("Table Name");

DBObject modifier = new BasicDBObject("counter", 1);
DBObject incQuery = new BasicDBObject("$id", modifier);

edited Jun 25, 2016 at 13:39

Tunaki

138k46 gold badges370 silver badges443 bronze badges

answered Jun 25, 2016 at 10:13

Anuraj Mahajan

1966 bronze badges

Collectives™ on Stack Overflow

Auto increment sequence in mongodb using java

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related