Adding a custom method to CRUDReposity interface in Spring Boot

Question

I'd like to add a method that finds a Todo item based on a given description. Online people are saying you can use JSQL and that Spring will automatically implement it. I tried the following:

public interface TodoRepo extends CrudRepository<Todo, Long> {

@Query("SELECT t FROM Todo t WHERE t.description=:description")
Todo findByDescription(@Param("description") String description);
}

However, I got an error saying that the symbol "@Query" could not be found. Is there some wiring or importing I'm failing to do? Is there another way to implement a custom method? Thanks!

Make sure you have import org.springframework.data.jpa.repository.Query; — Prakash Ayappan
– Prakash Ayappan, Commented Jun 10, 2018 at 17:54
Just read this guide: spring.io/guides/gs/accessing-data-jpa — Cepr0
– Cepr0, Commented Jun 10, 2018 at 18:24
Apart from any dependency problems that you’re obviously having. It is sufficient to just write an unannotated method findByDescription(String description) to have Spring data JPA implement it for you. — Strelok
– Strelok, Commented Jun 11, 2018 at 14:13

Jens Schauder · Accepted Answer · 2018-06-11 07:34:50Z

2

Something is wrong with your dependencies and or imports.

The @Query annotation is part of Spring Data JPA, which you intend to use.

There are two things you have to verify:

Spring Data JPA is on the classpath
You are importing org.springframework.data.jpa.repository.Query

If you update your question with your Maven configuration or comparable and/or a more complete java file including the imports we might give more detailed advice.

answered Jun 11, 2018 at 7:34

Jens Schauder

82.6k35 gold badges199 silver badges379 bronze badges

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

Collectives™ on Stack Overflow

Adding a custom method to CRUDReposity interface in Spring Boot

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related