Spring @GetMapping returning empty array

Question

When use GET with postman on link http://localhost:8081/api/data/mydatas/admin

i get an empty array. I've also tried adding { "username": "admin" } but it still returns as an empty array.

this is the code in my java service:

@GetMapping("/mydatas/{username}")
    public List<Data> findByUsername(String username) {

        Query q = em.createQuery("select data from Data data where data.username = :username");
        q.setParameter("username", username);
        List<Data> mydatas = q.getResultList();
        return mydatas;
        
        }

However, if i add username = "admin"; as below. It will send back the array with full of data.

    @GetMapping("/mydatas/{username}")
    public List<Data> findByUsername(String username) {

        username = "admin";

        Query q = em.createQuery("select data from Data data where data.username = :username");
        q.setParameter("username", username);
        List<Data> mydatas = q.getResultList();
        return mydatas;
        
        }

What am i doing wrong? Ps i am a novice still struggling with the basics.

Try to add @PathVariable to your parameter username.

C. Weber
– C. Weber

2020-08-13 08:53:20 +00:00
Commented Aug 13, 2020 at 8:53 — C. Weber
– C. Weber, Commented Aug 13, 2020 at 8:53

asgarov1 · Accepted Answer · 2020-08-13 08:52:42Z

4

add @PathVariable before your parameter like so

@PathVariable String username

With this annotation you are telling Spring to grab username from URL path

answered Aug 13, 2020 at 8:52

asgarov1

4,3402 gold badges12 silver badges26 bronze badges

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

Comments

tknkrtl · Accepted Answer · 2020-08-13 08:53:29Z

2

You need to use @PathVariable,

public List<Data> findByUsername(@PathVariable("username") String username)

answered Aug 13, 2020 at 8:53

tknkrtl

976 bronze badges

Comments

Aneesh · Accepted Answer · 2020-08-13 08:57:33Z

0

The @PathVariable annotation should be passed in with the name of the field in speechmarks "" as the argument for findByUsername before "String username"

answered Aug 13, 2020 at 8:57

Aneesh

1481 silver badge10 bronze badges

Collectives™ on Stack Overflow

Spring @GetMapping returning empty array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related