Getting javax.persistence.NonUniqueResultException

[rodrigo.uchoa]

Hey guys,

I'm getting a "javax.persistence.NonUniqueResultException" when doing a very simple query. My query goes something like this:

{code}

AuditQuery query = queryCreator.forRevisionsOfEntity(entity.getClass(), false, true);

query.add(AuditEntity.id().eq(entity.getId()));

query.getResultList();

{code}

Nothing fancy about it. Still, I'm getting the following exception. The stack trace suggests it has something to do with the @OneToOne mappings:

javax.persistence.NonUniqueResultException

at org.hibernate.envers.query.impl.AbstractAuditQuery.getSingleResult(AbstractAuditQuery.java:111)

at org.hibernate.envers.entities.mapper.relation.OneToOneNotOwningMapper.mapToEntityFromMap(OneToOneNotOwningMapper.java:74)

at org.hibernate.envers.entities.mapper.MultiPropertyMapper.mapToEntityFromMap(MultiPropertyMapper.java:118)

at org.hibernate.envers.entities.EntityInstantiator.createInstanceFromVersionsEntity(EntityInstantiator.java:93)

at org.hibernate.envers.query.impl.RevisionsOfEntityQuery.list(RevisionsOfEntityQuery.java:126)

at org.hibernate.envers.query.impl.AbstractAuditQuery.getResultList(AbstractAuditQuery.java:100)

Does anyone have a clue?

[adamw]

Not really ... which version of Envers? Is it reproducible with a test?

Adam

[rodrigo.uchoa]

Hi Adam,

It´s version 1.2.2. The problem misteriously vanished after a full database recreate. Do you think it might have something to do with corrupted data? One-to-one relationships that were actually one-to-many due to lack of unique constraints.

Thank you!

[adamw]

It must have been ... a duplicate record somewhere - that's what the exception would suggest.

Next time maybe try to look for records with duplicate ids.

Adam