Setting createdBy and updatedBy in JPA entities automatically

Question

I'm working on a JPA (Hibernate implementation of), Spring and Stripes web app. I have a number of JPA entities that have the following fields in common for both audit and query purposes:

createdBy - the user ID of the person who created the entity. createdOn - the date the entity was created updatedBy - the user ID of the person who last updated the entity updatedOn - the date the entity was last updated

I've got my app working so that createdOn and updatedOn are set automatically when the entity is persisted but I'm not sure how I can get the createdBy and updatedBy fields populated without having to pass through the currently logged in user's ID all the way from the controller class to the DAOs.

Does anyone have any suggestions on how I might do this without passing userIDs all over the place? Note that the current user ID is stored in the HttpSession object at the moment, so my backend needs to somehow access this data...

Thanks!

Salamanca

You don't wanna set the createdBy and updatedBy in the controller before persisting it? – Antiphony

What mechanism did you used for checking if object dirty, so you set updateBy/At fields? I asked related question, please checkout it: #20620906 – Inappetence

Answer 1

I've decided that a ThreadLocal is probably the cleanest way to do this in my application.

Salamanca

Answer 2

You can have a look at one of these approaches to pass the user ID as context in the business layer:

• How To Pass Context Between Layers With ThreadLocal And EJB 3
• How To Pass Context In Standard Way - Without ThreadLocal

(The posts may still be relevant even if you're not using EJB. The second post make sense however only if you use Spring with JTA)

I personally discourage these approach, as I perceive two problem with it:

• Testability: contextual data will need to be set up in the test
• Contract: contextual data participate in the contract to use the entity but is not clearly visible in the interface.

Passing userID "all over the place" may seem like a big job, but I think it's cleaner.

To set the date and user ID automatically when entity is created or update, you can use an EntityListener or lifecycle callbacks (maybe you're already doing that). Hope it helps...

Constantan

Answer 3

I'd create a class like this:

@MappedSuperclass
public abstract class AuditableDomainClass {
  private long createdBy;
  private long updatedBy;

  //getters and setters

Your entity classes that have the requirement you've described would simply extend this class, you'd set you variables in the layer you need to (controller for example) and you don't need to worry about it all the way down in the DAOs.

Murder

Yeah, I already have something like this - my problem is that I didn't want to pass the variables in from the controller layer - but it looks like I might have to. – Salamanca