Databases
StackOverflow2013
Postsdbo
POJava MongoTemplate: Upserts Not Generating ObjectId
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJava MongoTemplate: Upserts Not Generating ObjectId
    primarykey
    data
    text
    <p>I've been working on a java app that uses MongoDB as form of storage, however I've run into a problem. When a user adds a comment in my app, it adds the document to the comments collection, then does an upsert for statistical data. However, the upsert only adds the first time (no calls after update or insert new data). Here's the relevant code:</p> <pre><code>public class CommentDAO implements ICommentDAO { @Autowired @Qualifier(value = "mongoDB") MongoTemplate mongoTemplate; public UserComment addComment(UserComment userComment) { updateStats(userComment, 1L); mongoTemplate.save(userComment); return userComment; } public void updateStats(UserComment userComment, Long offset) { Update update = new Update(); update.inc("total", offset); Query query = query(where("entity").is(userComment.getEntity())); WriteResult wr = mongoTemplate.upsert(query, update, CommentStat.class); } } </code></pre> <p>Here's an example of the results in my comments collection:</p> <pre><code>{ "_id" : ObjectId( "50ab0566e4b0ea8f74b82d48" ), "_class" : "com.test.models.comment.UserComment", "userId" : 4, "ownerId" : 3, "comment" : "Test comment", "type" : "ART", "entity" : "759446489112216656", "date" : Date( 1353385318079 ) }, { "_id" : ObjectId( "50ab0691e4b0775cf7daacad" ), "_class" : "com.test.models.comment.UserComment", "userId" : 4, "ownerId" : 3, "comment" : "Another test", "type" : "ART", "entity" : "759446489112216656", "date" : Date( 1353385617619 ) } </code></pre> <p>...and my single, lonely stat...</p> <pre><code>{ "entity" : "759446489112216656", "total" : 1 } </code></pre> <p>Notice the missing "_id" and "_class" on the stat collection. I'm not getting any errors in my mongo or tomcat logs. Has anyone ever run into this problem before or know what the deal is? Thanks for your help!</p> <p><strong>Note:</strong> If I remove the upsert and add the stat normally, everything adds fine (this, of course, adds multiple stats for a single entity, which isn't desirable)</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMr.Radar
    1. USuser1837661
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POJava MongoTemplate: Upserts Not Generating ObjectId
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POJava MongoTemplate: Upserts Not Generating ObjectId
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POJava MongoTemplate: Upserts Not Generating ObjectId
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan you provide the version of MongoDB you are running against and more information on the stats collection? You can print out a collection summary on the mongo shell by running db.statistics.stats() - substituting "statistics" with your collection name.
      singulars
      1. POJava MongoTemplate: Upserts Not Generating ObjectId
      1. USJames Wahlin
    2. COhow did you output your entry from the stat collection? It's not possible that it would get inserted into MongoDB without an ObjectId() - so is this what it looks like from Java POV before the upsert?
      singulars
      1. POJava MongoTemplate: Upserts Not Generating ObjectId
      1. USAsya Kamsky
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload