I would like to implement Auditable so that each time a record is modified a new copy is saved.

I tried the following with interceptor and long sessions:

- from isUnsaved return true for all Auditables, then clear the id from onFlushDirty: isUnsaved() was not called for the entity i passed to the long session's saveOrUpdate(?!), several others were passed... also changing the id results in an exception

- saveOrUpdateCopy (was misled by the name, it's for something else)

- call evict(entity) and save(entity): this approach works, but it only works for root entities, it fails if the entity is saved due to some cascading because it's not implemented in an interceptor.

so my question is: can i achive from an interceptor that entities that implement Auditable and are (directly/indirectly) passed to saveOrUpdate() will automatically be saved into a new row?

thanks in advance,

- 101

Use a database trigger.

trying... but what if i would like to avoid triggers?

it's so close with hibernate, it only needs a little something. it's either me missing it or a few lines are missing from hibernate...

and if there's no other way, and if it's not too offtopic, could someone help me with the ?????? part?

thanks all,

- 101


CREATE OR REPLACE TRIGGER AUDITING
BEFORE UPDATE
ON SITE_QUESTION
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
Declare

rs SITE_QUESTION%rowtype;

Begin

select * into rs from SITE_QUESTION where id = :old.id;

select HIBERNATE_SEQUENCE.nextval into rs.id from dual;

insert into SITE_QUESTION ??????;

End;

of course i'm trying to avoid enumerating all columns here...

i've decided to open a new session each time i need to save a new copy from the interceptor. this app is not performance critical, so it works fine this way.

but still it would be good to have support for this in hibernate.

as long as you open the session on the same connection, this is the correct solution and should not harm performance.

hmm... currently i open a new session with a NEW connection. it's in a JCA environment, is there a way to get the calling session from the interceptor?

i have a threadlocale with the session, can i safely assume that Hibernate is single threaded so i can use this threadlocale to access the calling session (to ask for the current sql connection)?

Yes. Actually it depend if your app is "single threaded".
threadSession.connection() and open a new one using a user provided conenction