CODEWITHSUNDEEP
javamongodbmongodb-querymongo-collection
sarath
sarath

Reputation: 455

creating unique index in mongoDB

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

Upvotes: 8

Views: 9941

Answers (2)

Cuga
Cuga

Reputation: 17904

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));
}

Upvotes: 16

BatScream
BatScream

Reputation: 19700

You need to pass a DBObject to the ensureIndex() method.

db.t.ensureIndex(new BasicDBObject("product_src",1))

But, the ensureIndex method has been deprecated since version 2.12, you need to use createIndex() instead.

db.t.createIndex(new BasicDBObject("product_src",1));

Upvotes: 7

Related Questions