Spring Data and MongoDB repository - how to create an update query?

Question

I have the following jpa repository:

   @Query("UPDATE PlayerAccount pa SET pa.password = ?3 WHERE pa.id = ?1 AND pa.password = ?2")
   @Modifying
   public int updatePasswordWithValidation(Long playerAccountId, String oldPasswordDB, String encodePassword);

Now, i would like to implement a similar update query for a mongoDB repository:

@Query("update( { _id: ObjectId(' $1 ') }, { $set: { messageStatus: $2} })")

But it doesn't work. any references to how a customized mongo repository update looks like?

Thanks

Oliver Drotbohm · Accepted Answer · 2019-03-14 22:03:42Z

10

The MongoDB query language is a query-only language. Thus, there's no such thing as an update query. If you need to executed dedicated updates with a Spring Data repository on top of MongoDB, you need a custom implementation method.

// Interface for custom functionality
interface SomeCustomRepository {
  void updateMethod(…);
}

// Custom implementation
class FooRepositoryImpl implements SomeCustomRepository {

  public void updateMethod(…) {
    mongoTemplate.update(…);
  }
}

// Core repository declaration combining CRUD functionality and custom stuff
interface FooRepository extends CrudRepository<Foo, ObjectId>, SomeCustomRepository {
  …
}

This approach is also described in the reference documentation.

edited Mar 14, 2019 at 22:03

answered Jul 20, 2014 at 13:45

Oliver Drotbohm

83.6k19 gold badges236 silver badges219 bronze badges

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

2 Comments

Madbreaks Over a year ago

Hey Oliver, link is 404

Sebastian Over a year ago

@Madbreaks this is update for specific release: docs.spring.io/spring-data/mongodb/docs/2.2.5.RELEASE/reference/…

Jehoshuah · Accepted Answer · 2015-02-04 06:03:19Z

-1

If you just pass the previously auto-created _id of the Object with the updated object values, MongoDB 'Update's rather than 'Create' a new instance.

answered Feb 4, 2015 at 6:03

Jehoshuah

7012 gold badges9 silver badges20 bronze badges

Collectives™ on Stack Overflow

Spring Data and MongoDB repository - how to create an update query?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related