Unit testing spring data DAOs

[balteo]

Hello,
I would like to know if there are patterns or tips for unit testing spring data methods using the @Query annotation such as the one below (taken from a "spring data" dao interface):

  @Modifying
  @Transactional
  @Query("UPDATE Account a SET a.accountActivated = true WHERE a.accountToken = ?1")
  int reactivateAccountFromToken(String accountToken);

By unit testing I mean using some sort of mock maybe but not hitting the database of course.
Regards,
Julien.

[Marten Deinum]

Then what would you test not the query as that gets translated/converted by the EntityManager which you could mock but that doesn't give you much.

I would create an integration test with maybe an in memory (H2, HSQLDB, Derby) database, but propably only for the complex queries the rest I would test with system tests.

[balteo]

Thanks Marten