Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Java MongoDB FindOne to get last inserted record

Tags:

java

mongodb

I am running a large data feed into Mongo that I need to have an external client connect to and tap into the feed from the last available record - not anything older than current. I have a tailable cursor that works just fine, but it starts at the beginning of the table, and I'd like to have it start at the most recently inserted record. I know how to do this, presuming I have the _ID of the last inserted record. My problem is that I can't get findOne working properly in Java to bring back the last inserted record. Put simply, I need the Java equivalent of this Mongo JS command:

db.market.findOne( {$query:{}, $orderby:{$natural:-1}} )

There are a couple of posts on here that I've found that seem similar, but they are assuming that the client is also the one inserting the records and already have knowledge of the last available ID.

Anyways, what would the proper corresponding Java code be to accomplish the same thing - that is getting the _ID of the last available record?

I guess as an alternative I could have my client insert a throwaway record, get that ID, and start from there, but I'd prefer to do this the right way.

Thanks

like image 843
mikepinch Avatar asked Apr 09 '14 14:04

mikepinch


3 Answers

To be clear, natural order is not insertion order, except in the case of capped collections. You will need another criteria to sort by.

Assuming you are using the default ObjectID, you can use this as a metric for insertion as the default value starts with the insertion time (to the millisecond) and is always unique.

You should also use a find, rather than a findOne. Try the following:

db.market.find({}).sort({_id:-1}).limit(1)
like image 101
daveh Avatar answered Oct 22 '22 02:10

daveh


if you want to do it in your JAVA code you cand do like this

Document myDoc = (Document)collection.find().sort(new BasicDBObject(<field>,-1)).first();

it will return a document the is the last inserted ordered by that significant field =)

like image 24
fils capo Avatar answered Oct 22 '22 03:10

fils capo


For anyone who is looking for a more recent answer:

Here's how you finding the last inserted element by "_id" with mongodb-driver in your Java project.

// connect to your collection. 
MongoCollection<Document> collection = database.getCollection("yourCollection");

//request last inserted doc
Document myDoc = collection.find().sort(new Document("_id", -1)).first();

Hope this helps!

like image 35
Alex Gordienko Avatar answered Oct 22 '22 02:10

Alex Gordienko