Hi,

would it be possible to add a custom "where clause" when we do a session.update(object)?

I see that adding a native sql in the xml mapping require one to explicitly map parameters wich i dont want. I want hibernate to generate the update sql and append my where clause with it.

Any help would be appreciated.

Chris,

As i said earlier if i use custom sql as mentioned in the link that u provided, i need to specify the complete update statements with bindings to parameters, which i dont want.
What i need is to reuse whatever update statement hibernate is generating but post append my where clause with it.

I've never tried it, but see if you can using an Interceptor and the onPrepareStatement(String sql) method

better yet, just override the event listener for update if you're using hibernate 3.x.

copy the original source, then add your where clause

however, this might be more work than you think

Chris,

I have implemented an "save" listener and it is giving me a "SaveOrUpdateEvent". How would I use it to add my where clause?

thanks
maq

don't know, never done anything like this before. Was hoping it made the preparedstatement available somewhere for ya.