Spring data jpa find by multiple fields in embedded key

Question

I need to find an object using two fields of an embedded key

Here is the embedded key:

public class OrderItemId implements Serializable {

    private static final long serialVersionUID = 1163347452811191867L;

    @Column(name = "order_code", length = 25)
    private String orderCode;

    @Column(name = "barcode", length = 25)
    private String barcode;

    // ....
}

Here is the class of the object I want to query:

@Entity
@Table(name = "order_item")
public class OrderItem {

    @EmbeddedId
    @NotNull
    private OrderItemId id;

    @Column(name = "quantity")
    private Integer quantity;

    @Column(name = "price")
    private Double price;

    // ...
}

As in this StackOverflow Answer

To query by embedded key orderCode, I can write something like this

public List<OrderItem> findById_OrderCode(String orderCode);

and it works!

But I don't know how to query by both orderCode and barcode. I have tried some forms of and but no use.

Please put your answer in a proper answer instead of putting it in the question. This will let others see that the question is answered. — Jens Schauder
– Jens Schauder, Commented Feb 22, 2019 at 7:22

Loc Truong · Accepted Answer · 2019-02-23 02:13:18Z

6

Never mind, I have figured out the query, it is

public OrderItem findById_OrderCodeAndId_Barcode(String orderCode, String barcode);

answered Feb 23, 2019 at 2:13

Loc Truong

3897 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Spring data jpa find by multiple fields in embedded key

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related