org.hibernate.QueryException: could not resolve property

[afroehlich]

Hey there,

I just ran into this QueryException while executing the following Query unsing Envers 3.5.0-SNAPSHOT.

auditReader.createQuery().forRevisionsOfEntity(CustomerOrderDO.class, true, false).add(
 AuditEntity.property("pk").eq(5).setMaxResults(20).getResultList();

The property is the primary key and of course exists. The corresponding column name is equal to it in the original and the audited table.

While debugging I came across a few properties which are not properties of my entity but may be helpfull:

'

originalId.pk

' and '

id.pk

' .

Does anymone know what the difference between and the purpose of these 'synthetic'-properties is?
At the moment I'm using '

originalId.pk

' instead of '

pk

' but I don't know if that is the intention.

Thanks for comments in advance,
Alex

[adamw]

Hello,

I don't know what your exception is, but, for restricting on primary keys of an entity, you should use the AuditEntity.id().eq(...) methods.

The "originalId" is a synthetic id which consists of the original id (pk) and the revision number. This is the primary key of the audit entity corresponding to an entity.

Adam

[afroehlich]

Ahh...yep, that's exactly what I've been looking for,
thanks alot for the fast reply!

cheers,
Alex