Hibernate PreInsertEventListener -> How to create a History Table

[buyapentiumjerk]

Hi,

I'm writing a SWING app with hibernate and I want to implement "a kind of" custom made audit trail.
For instance I have one Class "Permissions" and when the user adds or edits a Permission I want to write to a table who, what and when edited/created a Permission.

I have a POJO Permissions:

@Entity
@Table(name = "PERMISSIONS", catalog = "DB_MUZIKKA")
public class Permissions implements Serializable, PreInsertEventListener {

	private static final long serialVersionUID = 1L;

	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	@Column(name = "PERMISSION_ID", unique = true, nullable = false)
	private long permissionId;
	@Column(name = "PERMISSION_NAME", nullable = false, length = 25)
	private String permissionName;
	@Column(name = "PERMISSION_DESCRIPTION", nullable = true, length = 255)
	private String permissionDescription;
	@Column(name = "PERMISSION_ACTIVE", nullable = false, length = 1)
	private Boolean permissionActive;
	@OneToMany(fetch = FetchType.LAZY, mappedBy = "permissionHistory")
	private List<PermissionsHistory> permissionHistoryList = new ArrayList<PermissionsHistory>();

...

Constructor/ Getters/ Setters

...

	@Override
	public boolean onPreInsert(PreInsertEvent arg0) {
		System.out.println("THIS IS A TEST -------------------------------------");
		Object object = arg0.getEntity();
		if (object instanceof Permissions) {
			Permissions entity = (Permissions) object;
			System.out.println(entity.getPermissionName().toString());
		}
		return false;
	}
}

And I have a POJO PermissionsHistory:

@Entity
@Table(name = "PERMISSIONS_HISTORY", catalog = "DB_MUZIKKA")
public class PermissionsHistory implements Serializable {

	private static final long serialVersionUID = 1L;

	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	@Column(name = "PERMISSIONHISTORY_ID", unique = true, nullable = false)
	private long permissionHistoryId;
	@Temporal(TemporalType.DATE)
	@Column(name = "PERMISSIONHISTORY_DATE", nullable = false)
	private Date permissionHistoryDate;
	@ManyToOne()
	@ForeignKey(name = "FK_PERMISSIONSHISTORY_PERMISSIONS")
	@JoinColumn(name = "PERMISSIONHISTORY_PERMISSION", nullable = false)
	private Permissions permissionHistory;

...

Constructors/ Getters/ Setters

As you can see I'm using a PreInsertEvent, and my idea is when someone creates or updates a Permission that information should be written on a table "PERMISSIONS_HISTORY" using a One (Permission) to Many (PermissionHistory) association.

My problem is that I'm not sure that this is how it should be implemented. How can I create a new PermissionHistory from Permissions Class??? This doesn't seem a very elegant way of doing this.

Please, any guidance is very appreciated.

Thank you.

[Tolls]

Isn't there an auditing mechanism as part of Hibernate?

Aha!

[buyapentiumjerk]

Hi Tolls,

didn't knew about that, but @ first look seems what I was looking for. Java world is a bit different from Micro$oft world, I was used to think in Audit Trail @ DB level.

Thank you.

[buyapentiumjerk]

ENVERS is exactly what I wanted, changing to SOLVED.