Mapping an entity with an embedded key

There is a class with an EmbeddedId.

@Entity @NoArgsConstructor @Getter @Setter @Table(name = "indicator_values") public class IndicatorValue { @EmbeddedId public IndicatorValueId id; @Column(name = "value") public BigDecimal value; // Конструктор для эксперимента (используется в репозитории) public IndicatorValue( String categoryCode, String indicatorCode, BigDecimal value, LocalDate effectiveDate ) { this.value = value; this.id = new IndicatorValueId(categoryCode, indicatorCode, effectiveDate); } }

Alongside it, there is an @Embeddable class that defines this ID.

@Embeddable @AllArgsConstructor @NoArgsConstructor @EqualsAndHashCode @Getter @Setter public class IndicatorValueId implements Serializable { @Column(name = "category_code") private String categoryCode; @Column(name = "indicator_code") private String indicatorCode; @Column(name = "effective_date") private LocalDate effectiveDate; }

And there is a repository (I’ve tried different methods to verify the result—this is not the complete list).

public interface IndicatorValueRepository extends JpaRepository<IndicatorValue, IndicatorValueId> { @Query(""" SELECT iv FROM IndicatorValue iv WHERE iv.id.indicatorCode = :indicatorCode AND iv.id.effectiveDate < :effectiveDate ORDER BY iv.id.effectiveDate DESC """) List<IndicatorValue> findByIndicatorCodeBeforeDate( @Param("indicatorCode") String indicatorCode, @Param("effectiveDate") LocalDate effectiveDate ); @Query(""" SELECT NEW by.vezhlivec.normsservice.entity.IndicatorValue( iv.id.categoryCode, iv.id.indicatorCode, iv.value, iv.id.effectiveDate ) FROM IndicatorValue iv WHERE iv.id.indicatorCode = :indicatorCode AND iv.id.categoryCode IS NULL AND iv.id.effectiveDate < :effectiveDate ORDER BY iv.id.effectiveDate DESC """) List<IndicatorValue> findByIndicatorCodeBeforeDate1( @Param("indicatorCode") String indicatorCode, @Param("effectiveDate") LocalDate effectiveDate ); List<IndicatorValue> findByIdIndicatorCode(String indicatorCode); List<IndicatorValue> findByValue(BigDecimal value); }

The core issue is that data is retrieved correctly only when I select a specific field, use a native query, or perform mapping via a constructor (as in findByIndicatorCodeBeforeDate1).

In all other cases—when attempting to fetch the entity or a list of entities—I either get null or a List with the correct number of elements, but every element is null.

Even the standard findById() returns null, despite the record definitely existing in the database.

Here is a test snippet from the service

List<IndicatorValue> iv = indicatorValueRepository.findByIdIndicatorCode("worker_4th_grade_hour_rate_construction"); System.out.println(iv); List<IndicatorValue> v = indicatorValueRepository.findByValue(new BigDecimal("13.02")); System.out.println(v); List<IndicatorValue> iv1 = indicatorValueRepository .findByIndicatorCodeBeforeDate("worker_4th_grade_hour_rate_construction", period.atDay(1)); System.out.println(iv1); List<IndicatorValue> iv2 = indicatorValueRepository .findByIndicatorCodeBeforeDate1("worker_4th_grade_hour_rate_construction", period.atDay(1)); for (IndicatorValue iv3 : iv2) { log.debug("Код категории: {}, код индикатора: {}, значение: {}, дата: {}", iv3.getId().getCategoryCode(), iv3.getId().getIndicatorCode(), iv3.getValue(), iv3.getId().getEffectiveDate()); } Optional<IndicatorValue> iv4 = indicatorValueRepository .findById(new IndicatorValueId( null, "worker_4th_grade_hour_rate_construction", LocalDate.of(2025, 9, 1) ) ); System.out.println(iv4.orElse(null));

and the corresponding log output.

2025-11-28T22:28:44.318+03:00 DEBUG 414781 --- [nio-8080-exec-2] org.hibernate.SQL : select iv1_0.category_code, iv1_0.effective_date, iv1_0.indicator_code, iv1_0.value from indicator_values iv1_0 where iv1_0.indicator_code=? 2025-11-28T22:28:44.323+03:00 TRACE 414781 --- [nio-8080-exec-2] org.hibernate.orm.jdbc.extract : extracted value (1:VARCHAR) -> [null] 2025-11-28T22:28:44.324+03:00 TRACE 414781 --- [nio-8080-exec-2] org.hibernate.orm.jdbc.extract : extracted value (1:VARCHAR) -> [null] 2025-11-28T22:28:44.324+03:00 TRACE 414781 --- [nio-8080-exec-2] org.hibernate.orm.jdbc.extract : extracted value (1:VARCHAR) -> [null] [null, null, null] 2025-11-28T22:28:44.326+03:00 DEBUG 414781 --- [nio-8080-exec-2] org.hibernate.SQL : select iv1_0.category_code, iv1_0.effective_date, iv1_0.indicator_code, iv1_0.value from indicator_values iv1_0 where iv1_0.value=? 2025-11-28T22:28:44.327+03:00 TRACE 414781 --- [nio-8080-exec-2] org.hibernate.orm.jdbc.extract : extracted value (1:VARCHAR) -> [null] 2025-11-28T22:28:44.327+03:00 TRACE 414781 --- [nio-8080-exec-2] org.hibernate.orm.jdbc.extract : extracted value (1:VARCHAR) -> [null] 2025-11-28T22:28:44.327+03:00 TRACE 414781 --- [nio-8080-exec-2] org.hibernate.orm.jdbc.extract : extracted value (1:VARCHAR) -> [null] 2025-11-28T22:28:44.327+03:00 TRACE 414781 --- [nio-8080-exec-2] org.hibernate.orm.jdbc.extract : extracted value (1:VARCHAR) -> [null] 2025-11-28T22:28:44.327+03:00 TRACE 414781 --- [nio-8080-exec-2] org.hibernate.orm.jdbc.extract : extracted value (1:VARCHAR) -> [null] [null, null, null, null, null] 2025-11-28T22:28:44.330+03:00 DEBUG 414781 --- [nio-8080-exec-2] org.hibernate.SQL : select iv1_0.category_code, iv1_0.effective_date, iv1_0.indicator_code, iv1_0.value from indicator_values iv1_0 where iv1_0.indicator_code=? and iv1_0.effective_date<? order by iv1_0.effective_date desc 2025-11-28T22:28:44.331+03:00 TRACE 414781 --- [nio-8080-exec-2] org.hibernate.orm.jdbc.extract : extracted value (1:VARCHAR) -> [null] [null] 2025-11-28T22:28:44.333+03:00 DEBUG 414781 --- [nio-8080-exec-2] org.hibernate.SQL : select iv1_0.category_code, iv1_0.indicator_code, iv1_0.value, iv1_0.effective_date from indicator_values iv1_0 where iv1_0.indicator_code=? and iv1_0.category_code is null and iv1_0.effective_date<? order by iv1_0.effective_date desc 2025-11-28T22:28:44.334+03:00 TRACE 414781 --- [nio-8080-exec-2] org.hibernate.orm.jdbc.extract : extracted value (1:VARCHAR) -> [null] 2025-11-28T22:28:44.334+03:00 TRACE 414781 --- [nio-8080-exec-2] org.hibernate.orm.jdbc.extract : extracted value (2:VARCHAR) -> [worker_4th_grade_hour_rate_construction] 2025-11-28T22:28:44.334+03:00 TRACE 414781 --- [nio-8080-exec-2] org.hibernate.orm.jdbc.extract : extracted value (3:NUMERIC) -> [13.02] 2025-11-28T22:28:44.334+03:00 TRACE 414781 --- [nio-8080-exec-2] org.hibernate.orm.jdbc.extract : extracted value (4:DATE) -> [2024-09-01] 2025-11-28T22:28:44.335+03:00 DEBUG 414781 --- [nio-8080-exec-2] b.v.n.s.i.u.IndicatorsUpdateService : Код категории: null, код индикатора: worker_4th_grade_hour_rate_construction, значение: 13.02, дата: 2024-09-01 2025-11-28T22:28:44.350+03:00 DEBUG 414781 --- [nio-8080-exec-2] org.hibernate.SQL : select iv1_0.category_code, iv1_0.effective_date, iv1_0.indicator_code, iv1_0.value from indicator_values iv1_0 where ( iv1_0.category_code, iv1_0.effective_date, iv1_0.indicator_code ) in ((?, ?, ?)) null