Indexing MongoDB collection in Java

Question

I am creating a collection in MongoDB in the following way and I want to create a 2dsphere index on location field of this collection from Java code. But I am not able to do so.

collection.ensureIndex() method expects a DBObject as a parameter but I cannot pass location to it.

How do I create collection.ensureIndex({"location" : "2dsphere"}) in Java code? MongoDB allows me to do so in command prompt. But, I want to index it through code written in Java.

BasicDBObject doc = new BasicDBObject("attr1", nextLine[0])
                              .append("attr2", nextLine[1])
                              .append("edge-metro-code", nextLine[6])
                              .append("location", new BasicDBObject("type", "Point")
                                                            .append("coordinates",latLong)) 
                              .append("attr3", nextLine[9])
                              .append("attr4", nextLine[10])

user508434 · Accepted Answer · 2014-07-09 11:41:10Z

3

ensureIndex() has been deprecated now. You should use createIndex() instead:

MongoClient mongoClient = new MongoClient();
DBCollection test = mongoClient.getDB("testdb").getCollection("test");
test.createIndex(new BasicDBObject("location","2dsphere"));

answered Jul 9, 2014 at 11:41

user508434

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

1 Comment

roottraveller Over a year ago

can you please share the doc link saying deprecated?

Miguel Cartagena · Accepted Answer · 2013-07-03 13:21:25Z

2

You should construct a new DBObject that represents your index. See the code bellow:

DBObject index2d = BasicDBObjectBuilder.start("location", "2dsphere").get();
DBCollection collection = new Mongo().getDB("yourdb").getCollection("yourcollection");
collection.ensureIndex(index2d);

edited Jul 3, 2013 at 13:21

answered Jul 3, 2013 at 10:49

Miguel Cartagena

2,60618 silver badges20 bronze badges

1 Comment

koustubhC Over a year ago

how do I use $near for the collection built with above structure of the document? I want to run a query from java which has $near in it. I tried QueryBuilder and BasicDbObject but could not find a right solution for it. Could you please help me on this?

Collectives™ on Stack Overflow

Indexing MongoDB collection in Java

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related