how to make findby with composite key in spring data - jpa -hibernate ? @EmbeddedId

Question

@Embeddable
public class AccountTransactionId implements Serializable {
    private String trxDate;
    private String acctNo;
    private int trxNo;
}

@Entity
public class Transaction {
    @EmbeddedId
    private AccountTransactionId accountTransactionId;

    private int amt;
    private int fee;
    private String cancelYn;
}

this is my repository. how to make the find method? i don't have any idea about that

List<Map<String, Object>> findByAccountTransactionId_trxDate(String trxDate);

i tried "findByAccountTransactionId_trxDate", "findByAccountTransactionIdTrxDate", "findByIdTrxDate"...

Please share your whole interface of Repository – Umang Soni Mar 11 '20 at 12:37 — Umang Soni, Mar 11 '20 at 12:37

score 6 · Answer 1 · edited Apr 24 '22 at 15:39

6

You could use @IdClass (https://attacomsian.com/blog/spring-data-jpa-composite-primary-key)

Then you can just pass the class in the example in the link, it would be

repository.findById(new AccoutId(accountno,accounttype)

This worked for me

edited Apr 24 '22 at 15:39

alex

2,464
23
32

answered Jan 07 '21 at 00:41

user3405326

81
1
5

can you please remove the link and put your answer here ? – phoenixstudio Jan 07 '21 at 01:15
You could use @IdClass Then you can just pass the class in the example in the link, it would be repository.findById(new AccoutId(accountno,accounttype) This worked for me – user3405326 Jan 08 '21 at 17:52

score 5 · Answer 2 · answered Dec 23 '20 at 20:39

I suggest having a look over the camel case if will change something; probably there is going to not work because of that.

Second, I would expect the method to return a list of objects, instead of a map. In your case, this is the solution I expect to work:

public interface TransactionRepository extends JpaRepository<Transaction, AccountTransactionId> {

    /**
      * here rename accountTransactionId to id 
      * and trxDate to trxdate
      */
    List<Object> findByIdTrxdate(String trxDate, String acctNo); 
    List<Object> findByAccountTransactionIdTrxDate(String trxDate, String acctNo);

}

score 4 · Answer 3 · answered Mar 11 '20 at 12:45

4

You can write like this:

public interface TransactionRepository extends JpaRepository<Transaction, AccountTransactionId> {

    List<Map<String, Object>> findByTrxDateAndAcctNo(String trxDate, String acctNo);

}

answered Mar 11 '20 at 12:45

Umang Soni

137
1
2
14

1

you are the one that i am waiting for – pebC Mar 15 '20 at 12:34
Check below example for more details:- https://www.callicoder.com/hibernate-spring-boot-jpa-composite-primary-key-example/ – Umang Soni Mar 18 '20 at 10:11
As far as I can tell this will throw an exception because type Transaction has no property trxDate – a1an Jan 29 '21 at 17:04

how to make findby with composite key in spring data - jpa -hibernate ? @EmbeddedId

3 Answers3