creating unique index in mongoDB

sarath picture sarath · Dec 31, 2014 · Viewed 7.3k times · Source

I am using a java program for mongo db insertion trying to create a unique index for a field. product_src is a field in my collection and I want to set it as unique index for avoiding the duplicate insertion. I am trying the following code but showing syntax error what is the problem with this.

DB db;
    try {
        sample = new MongoClient("myIP",PORT);
        db = sample.getDB("client_mahout");
        t = db.getCollection("data_flipkart_in_avoid_duplicate_checking");
        System.out.println("enter the system ip");
        db.t.ensureIndex({"product_src":1});
    } catch (Exception e) {}

t is the collection. there is problem with line db.t.ensureIndex({"product_src":1});

Please give me a sample code how to create unique index in mongo DB

Answer

Cuga picture Cuga · Jan 14, 2016

For future reference, the way to handle this in the Java Mongo driver v3.0+ is by:

public void createUniqueIndex() {
    Document index = new Document("field", 1);
    MongoCollection<Document> collection = client.getDatabase("db").getCollection("Collection");
    collection.createIndex(index, new IndexOptions().unique(true));
}