Envers - Are these Issues?
Hi Adam,
By following up your notes/forum I was able to configure the envers in Spring+Hibernate 3.2.x+envers.1.0.0.ga+Oracle environment.
I still owe you a "Quick Start" guide for Spring/above environment.
Here are the current issues that I am facing with and I am not sure if these are Envers issue or not. Can you please clarify.
Case: I am building entity version for my Account Entity
Problems:
1. My Account class has many-to-one relation ship with entity AccountType which is a type table. As it is a type table(always constant), I dont have the need of entity versioning for this. I get the below error message in this case.
org.hibernate.MappingException: A versioned relation to a non-versioned entity com.package.name.*.AccountType!
2. We use specialized data type by extending the existing data type. For example, Date class, we have our own version CTSCalendarDate/CTSCalendarDateType. In *.hbm.xml files we use this type instead of Date. This field is Oracle Date type in table/database. Will Envers support this. Currently, I am getting the below exception.
org.hibernate.MappingException: Could not determine type for: CTSCalendarDateType, at table: ACCOUNT_VERSIONS, for columns: [org.hibernate.mapping.Column(INSERTED_DT)]
3. I tried to use my @RevisionEntity as we are in Oracle environment. Below is my class. For some reason this class is not detected by envers and it was still using _revisions_info. Do I need to create a bean for this class and inject to some other beans?. Currently, this class was not recognized by Envers in my environment.
package com.package.name;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
import org.jboss.envers.RevisionEntity;
import org.jboss.envers.RevisionNumber;
import org.jboss.envers.RevisionTimestamp;
@Entity
@RevisionEntity
@Table(name="REVISIONS_INFO") // any name you like
public class ExampleRevEntity {
@Id
@GeneratedValue // any auto-generated value is ok
@RevisionNumber
@Column(name="REVISION_ID")
private int id; // can also be a Long
@RevisionTimestamp
@Column(name="REVISION_TIMESTAMP")
private long timestamp;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public long getTimestamp() {
return timestamp;
}
public void setTimestamp(long timestamp) {
this.timestamp = timestamp;
}
public boolean equals(Object o) {
if (this == o) return true;
if (!(o instanceof ExampleRevEntity)) return false;
ExampleRevEntity that = (ExampleRevEntity) o;
if (id != that.id) return false;
if (timestamp != that.timestamp) return false;
return true;
}
public int hashCode() {
int result;
result = id;
result = 31 * result + (int) (timestamp ^ (timestamp >>> 32));
return result;
}
}
If you could modify/remove the underscore from VersionsEntitiesConfiguration.java as
verEntCfg.revisionsInfoEntityName = "revisions_info"
I believe Oracle database can also work with the default setting.
Thanks,
vbforums
