Springboot jpa, get rows with specific fields using two joins

Question

I have entities :Student, Class, Room.

student M-M class, student M-M rooms, thus two junction tables. Now I want to get all students assigned to class X and room Y. Thus I've made:

@Query("SELECT s from Student s INNER JOIN s.classes c INNER JOIN s.rooms r WHERE c.id LIKE ?1 AND r.id LIKE ?2")
Page<Student> findAllInClassAndRoom(final Long classId, final Long roomId, final Pageable pageable);

But it gives me wrong results. Is there an error in my query ?

I think you should not use LIKE when searching by id

Dazak
– Dazak

2018-04-12 21:01:33 +00:00
Commented Apr 12, 2018 at 21:01 — Dazak
– Dazak, Commented Apr 12, 2018 at 21:01

Henrique Fernandes Cipriano · Accepted Answer · 2018-04-13 02:34:38Z

1

The only error in your query is the LIKE statement. Just change the equal sign "=". As below:

@Query("SELECT s from Student s INNER JOIN s.classes c INNER JOIN s.rooms r WHERE c.id = ?1 AND r.id = ?2")
Page<Student> findAllInClassAndRoom(final Long classId, final Long roomId, final Pageable pageable);

The LIKE statement allows a greater mass of data. Because it would allow any Room or Class that part of the code is the id entered as a parameter. LIKE statement specification

answered Apr 13, 2018 at 2:34

Henrique Fernandes Cipriano

5857 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Springboot jpa, get rows with specific fields using two joins

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