Spring Data JPA find by embedded object property

Question

I want to write a Spring Data JPA repository interface method signature that will let me find entities with a property of an embedded object in that entity  Does anyone know if this is possible  and if so how   Here s my code    Entity  Table name    BOOK UPDATE QUEUE   indexes     uniqueConstraints    UniqueConstraint columnNames              bookId    region     name    UK01 BOOK UPDATE QUEUE    public class QueuedBook implements Serializable         Embedded      NotNull     private BookId bookId                Embeddable public class BookId implements Serializable         NotNull      Size min 1  max 40      private String bookId        NotNull      Enumerated EnumType STRING      private Region region               public interface QueuedBookRepo extends JpaRepository lt QueuedBook  Long gt           I d like to write a method like this  but can t figure out how to search by region        when region is actually a part of the embedded BookId     Page lt QueuedBook gt  findByRegion Region region  Pageable pageable        Can I write a query for this using Spring Data

User · Accepted Answer

This method name should do the trick   Page lt QueuedBook gt  findByBookIdRegion Region region  Pageable pageable     More info on that in the section about query derivation of the reference docs

User · Answer

The above - findByBookIdRegion   did not work for me  The following works with the latest release of String Data JPA   Page lt QueuedBook gt  findByBookId Region Region region  Pageable pageable

User · Answer

According to me  Spring doesn t handle all the cases with ease  In your case the following should do the trick  Page lt QueuedBook gt  findByBookIdRegion Region region  Pageable pageable       or  Page lt QueuedBook gt  findByBookId Region Region region  Pageable pageable     However  it also depends on the naming convention of fields that you have in your  Embeddable class    e g  the following field might not work in any of the styles that mentioned above   private String cRcdDel    I tried with both the cases  as follows  and it didn t work  it seems like Spring doesn t handle this type of naming conventions i e  to many Caps   especially in the beginning - 2nd letter  not sure about if this is the only case though   Page lt QueuedBook gt  findByBookIdCRcdDel String cRcdDel  Pageable pageable      or   Page lt QueuedBook gt  findByBookIdCRcdDel String cRcdDel  Pageable pageable     When I renamed column to   private String rcdDel    my following solutions work fine without any issue   Page lt QueuedBook gt  findByBookIdRcdDel String rcdDel  Pageable pageable      OR   Page lt QueuedBook gt  findByBookIdRcdDel String rcdDel  Pageable pageable

User · Answer

If you are using BookId as an combined primary key  then remember to change your interface from   public interface QueuedBookRepo extends JpaRepository lt QueuedBook  Long gt      to   public interface QueuedBookRepo extends JpaRepository lt QueuedBook  BookId gt      And change the annotation  Embedded to  EmbeddedId  in your QueuedBook class like this   public class QueuedBook implements Serializable     EmbeddedId  NotNull private BookId bookId

[java] Spring Data JPA find by embedded object property

Examples related to java

Examples related to spring

Examples related to jpa

Examples related to spring-data

Examples related to spring-data-jpa