Issues

Select view

List view

Detail view

Select search mode

Basic

JQL

Envers fails to initialize Map with Embeddables (Could not resolve attribute 'REVTYPE' of 'java.util.Map')
HHH-18779
Deploying Hibernate on WAS 8.5.5 tries to use Liberty JTA Platform
HHH-16134
Metamodel imports cache increases indefinitely for dynamically generated HQL aliases eventually leading to an OOM
HHH-14948
Resolved issue: HHH-14948
Converters defined through orm.xml are never retrieved from the CDI context
HHH-14881
Resolved issue: HHH-14881
<converter class="..."> in orm.xml ignores the <package> element
HHH-14880
Resolved issue: HHH-14880

5 of 5

Envers fails to initialize Map with Embeddables (Could not resolve attribute 'REVTYPE' of 'java.util.Map')

Description

There is a problem when an entity with a Map containing @Embeddable values is loaded from Envers.

package datamodel;

import org.hibernate.envers.Audited;
import jakarta.persistence.*;

@Audited
@Entity
@Table(name = "users")
public class User {
	@Id
	@GeneratedValue(strategy = GenerationType.SEQUENCE)
	private long id;
}

@Embeddable
public class Address {
	@Column
	private String street;
}
@Audited
@Entity
public class UserAddress {
	@Id
	@GeneratedValue(strategy = GenerationType.SEQUENCE)
	private long id;

	@ElementCollection(fetch = FetchType.EAGER)
	private Map<User, Address> entries = new HashMap<>(); // the map
}

The problem occurs when a UserAddress entity is loaded via Envers:

final List<UserAddress> revisions = getAuditReader().createQuery()
	.forRevisionsOfEntity(UserAddress.class, true, true)
	.add(AuditEntity.id().eq(userAddressId)) // identifier
	.getResultList();
revisions.getFirst().getEntries().size(); // Exception

The following Exception is thrown:

IllegalArgument org.hibernate.query.sqm.UnknownPathException: Could not resolve attribute 'REVTYPE' of 'java.util.Map' [select new list(ee__, e__) from UserAddress_entries_AUD ee__, datamodel.User_AUD e__ where ee__.originalId.mapkey_id = e__.originalId.id and ee__.originalId.UserAddress_id = :UserAddress_id and e__.originalId.REV.id = (select max(e2__.originalId.REV.id) from datamodel.User_AUD e2__ where e2__.originalId.REV.id <= :revision and e__.originalId.id = e2__.originalId.id) and ee__.originalId.REV.id = (select max(ee2__.originalId.REV.id) from UserAddress_entries_AUD ee2__ where ee2__.originalId.REV.id <= :revision and ee__.originalId.UserAddress_id = ee2__.originalId.UserAddress_id and ee__.street is not distinct from ee2__.street and ee__.originalId.mapkey_id = ee2__.originalId.mapkey_id) and ee__.originalId.REVTYPE != :delrevisiontype and e__.originalId.REVTYPE != :delrevisiontype]

A full reproducer is attached.

Attachments

29 Oct 2024, 01:09 PM

Details

Assignee

Unassigned

Reporter

Lukas

Labels

Components

hibernate-envers

Affects versions

5.3.23

5.6.15

6.6.1

Priority

Major

Created October 29, 2024 at 1:04 PM

Updated November 14, 2024 at 8:18 AM

Configure

Activity

Show:

stringintech November 5, 2024 at 9:38 PM
Edited

Apparently, the issue was first reported in https://hibernate.atlassian.net/browse/HHH-11841 and fixed, but that fix was reverted because it caused a new issue (https://hibernate.atlassian.net/browse/HHH-12018 ). A proper fix was planned in https://hibernate.atlassian.net/browse/HHH-12043 , but it hasn’t been done yet.
Also see EntityMapCompositeElementTest.