Fetching associated entities with AuditQuery

Question

For example I have two entities:

@Entity
@Audited
@Table(....
public class Worker
{
    private Long id;
    private String name ;
}

@Entity
@Audited
@Table(....
public class Department
{
    private Long id;
    private String departmentName;
    private Worker worker;

}

I want to display the following data for Department:

| departmentName | name (from fetched entityworker) |

When using AuditQuery to get audit information for entity Department, is it possible to fetch the entity Worker to display name value for more human readable display?

score 1 · Accepted Answer · answered Aug 21 '15 at 21:52

1

This feature is not supported, so you'll have to use a native query and join the actual database tables.

answered Aug 21 '15 at 21:52

Vlad Mihalcea

142,745
71
566
911

I solved my problem by initializing proxies using java reflection. – danizmax Aug 24 '15 at 08:09
You can also add the answer here, maybe it will help others too. – Vlad Mihalcea Aug 24 '15 at 08:12

score 0 · Answer 2 · edited May 23 '17 at 12:22

0

EAGER loading is not supported by envers, all association can only be lazy loaded. An alternative solution to doing joins by hand, is initializing lazy fields of an entity.

My solution to this problem was to go through all fields using java reflection (see), finding proxies by using Hibernate.isInitialized(...) and initializing them with Hibernate.initialize(...).

edited May 23 '17 at 12:22

Community

1
1

answered Aug 24 '15 at 08:29

danizmax

2,446
2
32
41

Fetching associated entities with AuditQuery

2 Answers2