Hibernate JPA returning duplicate records

Question

I am building a spring rest API which will return promo information (promo_code, promo_description, efective_date,expiration_date) and I have the table structure like blow

PROMO_DETAIL SEQ_NO NUMBER(9), //PK PROMO_CODE VARCHAR2(9), //PK PROMO_DESCRIPTION VARCHR2(100), EFFECTIVE_DATE DATE, EXPIRATION_DATE DATE

I am using an entity class having promo_code,promo_description,effective_date and expiration_date. I annotated only promo_code with @Id. I am directly returning the entity class as the response.

Problem is when there is 2 records with same promo code(but with different values of other fields). Though In this case JPA returns two records however both records have duplicate values for all fields.

Same type of question was asked here as well "JPA/Hibernate select query returning duplicate records"

Solution is to composite key in entity.

I do not want to add seq_no to entity class because it is not required in response. I also do not want to create unnecessarily separate response model class. It will create extra overhead of mapping entity to model class.

Is there any other solution to this problem?

Why have you annotated promo_code with @Id if two records can have same value for it? — chepaiytrath
– chepaiytrath, Commented Jun 10, 2018 at 10:13
The @Id annotation marks a field as a primary key field. As per ur description, promo_code doesn't sound like a primary key. — chepaiytrath
– chepaiytrath, Commented Jun 10, 2018 at 10:24
as the field cannot be individually used as a primary key, u should either find a field than can be used as one OR declare a composite key. — chepaiytrath
– chepaiytrath, Commented Jun 10, 2018 at 10:26
I do not want to add seq_no to entity class because it is not required in response: the HTTP response to some web service you're writing shouldn't drive the design of your entity. If you don't want to send it in the response, then just don't. But it must be in the entity, and must be part of its ID. (That said, not sending it in the response will make it impossible to expose a service that returns one promo_detail by ID, since the client will never know what its ID is) — JB Nizet
– JB Nizet, Commented Jun 10, 2018 at 11:01

Collectives™ on Stack Overflow

Hibernate JPA returning duplicate records

0

Linked

Hot Network Questions

Collectives™ on Stack Overflow

0

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Linked