Hi all.

I need to modify an A entity when other (unrelated) B entity is deleted.
What I need is to load A from DB when interceptor executes 'onDelete' method over B entity.

The problem is that I can't open a new transaction because I need the Hibernate rollback management to undo my manual modification if anything goes wrong during the commit.

Also I have tried to use 'getEntity' method but it does not load the entity.

Do you understand my scenario and my problem?
Any idea?

Thanks in advance!

Hi,
I had a similar problem where I wanted to query the DB and set a generated identifier (other than the primary key) in the interceptor. Yes, you are right that you can't start a new transaction. I think interceptor is the last possible artifact that Hibernate exposes before stuff is fired to the database. Anyway, you may however fire native SQL. This was my workaround.
https://forum.hibernate.org/viewtopic.php?f=1&t=995904
I raised the query and also answered it :)
Hope this helps you.

Thanks, it works: I have executed a SQL query within onDelete method...

But now I have the next problem:
really, A entity I want to modify is related to B in this way: A -> B, this is, there is an association (unidirectional aggregation) between both entities, so I need to set null the A's foreign key (to B) just before delete B. And I must to do this in the same transaction. But if I set a.setB(null) (with a SQL query), this is not visible in the moment of delete B so I get a ConstraintViolationException.

How could I do that?

If you are using native SQL it should work. Native SQL will bypass the first and second level cache and will be directly sent to the DB.
Can I see the query that you are using (and some related code that you feel is necessary)?

Ok, you are right... it works fine.

Thank you.

How could I evaluate as positive your answer? is there a credit system in this forum? (I can't see the link/button)

Oh I don't know about that! But I'm glad that I could be of help!
Cheers!