mikepinch
mikepinch

Reputation: 673

Java MongoDB FindOne to get last inserted record

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

Upvotes: 20

Views: 52070

Answers (5)

Guilherme Reis
Guilherme Reis

Reputation: 67

The best way:

.findOne({[WHERE]}, {sort: {_id: -1}, limit: 1 });

db.market.findOne({}, {sort: {_id: -1}, limit: 1 });

Upvotes: 2

Amal lal T L
Amal lal T L

Reputation: 430

Document lastInsertion = new MongoClient().getDatabase("collectionName").find().sort(new BasicDBObject("_id", -1)).first();
lastInsertion.get("key");

Upvotes: 1

Alex Gordienko
Alex Gordienko

Reputation: 21

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!

Upvotes: 2

fils capo
fils capo

Reputation: 316

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 =)

Upvotes: 2

daveh
daveh

Reputation: 3706

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)

Upvotes: 55

Related Questions