RelationTargetAuditMode.NOT_AUDITED and @OneToMany

[flexpert]

Hi,

I'm having a hard time getting RelationTargetAuditMode.NOT_AUDITED to work on a @OneToMany relationship. Is this supposed to be supported?

In my case Entity A is marked @Audited and has a @OneToMany to the not-audited entity B, e.g.

// in entity A (A is @Audited)

@Audited(targetAuditMode = RelationTargetAuditMode.NOT_AUDITED)
@OneToMany(mappedBy = "a")

public Set<B> getBs()

// in entity B (B is not marked as @Audited)

@ManyToOne(
@JoinColumn(name = "a_id")
public A getA()

This causes a MappingException in the AuditMetadataGenerator.getReferencedIdMappingData() method: "An audited relation from A to a not audited entity B"

I'm using Envers 1.2.2 GA

Dirk

[adamw]

Ah, the problem here is that the relation is in fact held in table B (it has a column A_id or sth like that), so if B is not audited, there's no place where the information could be held. I only used relations in the other direction and then it works.

Here a special join table would be probably needed. But for now it won't work. If you can, please open a JIRA feature request.

Adam

[cbourque1]

Is there a fix for that problem?

[adamw]

Well there are three possibilities: either audit both entities, use a join table to hold the relation or write a patch to store the audit in a join table in this special case

Adam

[cbourque1]

Thanks Adam!

[ibenjes]

Hi,

what is the status on this one? I just came accross it on the first entity I've enabled for auditing but if OneToMany relationships to not-audited entities isn't working then this kills envers for me unfortunately.  I have a lot of these relationships where the other side doesn't have to be audtited and I can't rewrite them all to use join tables.

I am using envers 1.2.2.ga for hibernate 3.3.

Btw. is there any way for envers to create the audit tables automatically even if hbm2ddl.auto is not used? I don't want to use hbm2ddl.auto=create/update in production but would still like to have envers create the audit tables automatically.

[adamw]

It works, but you'll have to use a newer Envers version I'm afraid.

As for schema generation, hbm2ddl.auto is currently the ony way.

Adam

[ibenjes]

Hi Adam,

just found the 1.2.3 release for Hibernate 3.3 on your blog

http://www.warski.org/blog/?p=257

Is it fixed in that version?

Thanks

Immo

[adamw]

Looking at the list at the blog post, it's not there, but I really don't have such a good memory to remember what was in each release .

But I would really recommend upgrading, there was Hibernate 3.5 and 3.6 meanwhile, and now Hibernate 4.0 is coming.

Adam

[ibenjes]

Upgrading isn't always that easy when you have something running in production. We are using Seam 2.2 as the framework and seam bundles it's choice of hibernate. I could try replacing the hibernate jars but that would need testing and testing.