Not found in annotated query error with @Query

Question

I am using spring data with REST. I have a table country and an Entity corresponding to it called Country.java

I have annotated my method in CountryRepositopry as

public interface CountryRepository extends Repository<Country, Short> {

    @RestResource(path = "bycode3")
        @Query("select c from Country c where c.codeAlpha3=?1 and c.active=1")
        Country findCountryByCodeAlpha3(@Param("code") String countryCode);
 }

I am getting following exception while starting tomcat-

Caused by: java.lang.IllegalStateException: Using named parameters for method public abstract com.persistence.entity.common.Country com.persistence.repository.CountryRepository.findCountryByCodeAlpha3(java.lang.String) but parameter 'code' not found in annotated query 'select c from Country c where c.codeAlpha3=?1 and c.active=1'!

score 18 · Answer 1 · answered Oct 24 '14 at 23:04

18

I got the fixed

Query needs be modified as

@Query("select c from Country c where c.codeAlpha3=:code and c.active=1")

Instead of ?1 it should be :code

answered Oct 24 '14 at 23:04

Vijay Kumar Rajput

1,071
1
10
30

score 12 · Answer 2 · answered Oct 13 '17 at 09:43

12

The text xxx in @Param("xxx") must be used in Query value.

answered Oct 13 '17 at 09:43

Tiina

4,285
7
44
73

score 2 · Answer 3 · answered Sep 06 '22 at 11:08

2

just an add-on to existing answers

@Query("select c from Country c where c.codeAlpha3=: code and c.active=1")

don't put space between ":code" as ": code" or else you will get error.

answered Sep 06 '22 at 11:08

Ravi

338
1
12

score 0 · Answer 4 · edited Feb 14 '20 at 17:39

If you are using @Param annotation, you should use same as ur entity class parameter and also use it same in "(@Param("code") String countryCode)" also:

public interface CountryRepository extends Repository<Country, Short> {

    @RestResource(path = "bycode3")
        @Query("select c from Country c where c.codeAlpha3=?1 and c.active=1")
        Country findCountryByCodeAlpha3(@Param("code") String countryCode);
 }

According to this, it should be changed like this:

@RestResource(path = "bycode3")
    @Query("select c from Country c where c.codeAlpha3=?1 and c.active=1")
    Country findCountryByCodeAlpha3(@Param("codeAlpha3") String countryCode);

score 0 · Answer 5 · answered Jun 24 '21 at 15:23

You can try this, but always make sure that the string value in @Param("code") is the same as the named variable value you want to use in your query.

@RestResource(path = "bycode3")
    @Query("select c from Country where c.codeAlpha3=:code and c.active=1")
    Country findCountryByCodeAlpha3(@Param("code") String countryCode);

Not found in annotated query error with @Query

5 Answers5