Hello

I have to move some part of logic placed in ORACLE triggers to java and involve hibernate as much as possible. Triggers store logic such as
- validating data, using :old and :new variables (%rowtype of according table), often performing selects of current or other tables.
- updating some fields of :new
- updating or inserting records of other tables.

validation() api does not provide session object so it can't check other records/tables.
Interceptor api does not provide session as well.

How can I better do that ?

Thank you