Custom sql function on save / update

wiyanto · **Joined:** Wed Aug 08, 2007 10:11 pm **Posts:** 3

hi,
i've extended database dialect class to register encryption sql function.
i want to use it for property in some entity automatically when we do

Code:

session.save(object);

or

Code:

session.update(object);

the property that saved or updated are using this function before saved and updated, does anyone have any idea how to do this ?

i don't want to use <sql-insert> or <sql-update> because it have some flaw for my needs.

Thanks

himawan · **Joined:** Sat Aug 19, 2006 6:31 pm **Posts:** 139

Yes it's possible using hibernate's Session Interceptors or event listeners.

You can register these listeners for persistent event such as Load, Update, Flush, etc.

You can read here for the details
http://www.hibernate.org/hib_docs/v3/re ... le/#events

wiyanto · **Joined:** Wed Aug 08, 2007 10:11 pm **Posts:** 3

thanks for quick reply,
i've seen the interceptor on a link that u provided.
yes it can modify the value of the property before the event, but the modification that i need is trying to use hql function for that property before the event, AFAIK it don't have any reference to do this ?