How to join two table when both has Composite Primary Key

Asked Dec 25 '18 at 13:24

Active Dec 25 '18 at 15:47

Viewed 67 times

There is two table Transactions and ResponseCode

I want to write hibernate 5.2 code without using HQL so that it generate this kind of select bellow

SELECT t.tranType
      ,t.tranId
      ,t.requestDate
      ,t.rcCode
      ,t.tranAmount
      ,r.description
      ,r.status
  FROM transactions t
  LEFT OUTER JOIN responseCode r
    ON t.rcCode = r.rcCode
   AND (r.lang = 'en')
 WHERE (t.merchant_id =5 )

Please, let me know how to join this two table using hibernate annotations in table @Entities so, that transactions table one record join to ResponseCode table one record

edited Dec 25 '18 at 15:47

asked Dec 25 '18 at 13:24

JiboOne

1,438
4
22
55

are you using repository ? I mean to say JPA or CRUD – Navin Gelot Dec 25 '18 at 13:27
Have you tried writing the HQL query yet? – Tim Biegeleisen Dec 25 '18 at 13:31
@Navin Gelot I'm using Hibernate JPA (no spring, or other framework) – JiboOne Dec 25 '18 at 13:36
@Tim Biegeleisen No, I did not tried to write HQL – JiboOne Dec 25 '18 at 13:38
It would have helped your question if you at least posted a skeleton of a possible HQL query. Otherwise, you are just asking us to write it for you from scratch. Nothing wrong with that, but it increases the chances that you won't get an answer. – Tim Biegeleisen Dec 25 '18 at 13:39
@Tim Biegeleisen here is the additional explanation of my problem https://stackoverflow.com/questions/53916500/hibernate-5-2-join-table-restriction-problem – JiboOne Dec 25 '18 at 13:41
Why have you asked a new, duplicate, question instead of improving your first one? – Joakim Danielson Dec 25 '18 at 15:34
@Joakim Danielson I have improved first one, do you have any Idea how to fix it? – JiboOne Dec 26 '18 at 08:44

How to join two table when both has Composite Primary Key

0 Answers0