How can I return Optional from @Query method?

Question

Is it possible to return optional from repository If @Query in Spring data JPA is used?

@Query("SELECT e FROM Employee m WHERE e.id=?1 AND e.card=?2")
Employee getById(Integer id, Card card);

user_13365258 · Answer

Yes, it is.

you just need to change the return type of your method to Optional. Your method will look like:

   @Query("SELECT e FROM Employee m WHERE e.id=?1 AND e.card=?2")
   Optional getById(Integer id, Card card);