Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp



In the hibernate mapping file
inside the class we have two properties called dynamic-update and dynamic-insert wht are the use of these properties.

I've gone thru hibernate document but i didnt get the clear picture.

kndly let me know the description.

(8)

dynamic-update (optional, defaults to false): Specifies that UPDATE SQL should be generated at runtime and contain only those columns whose values have changed.
(9)

dynamic-insert (optional, defaults to false): Specifies that INSERT SQL should be generated at runtime and contain only the columns whose values are not null.

http://www.hibernate.org/hib_docs/v3/re ... tion-class

OK, I will try to explain: let us suppose we have object that has 10 fields, then we create one and initialize one field only, with dynamic insert the statement will have two values like this
insert into table (id, fieldName1)values( 0, 'zz'),
without dynamic insert it will look like
insert into table (id, fieldName1,fieldName2,....)values( 0, 'zz', null,...);

same about dynamic updates

Is there any way to change this behaviour at runtime?

Something like: session.setDynamicUpdate(Order.class)?

It would be very useful if you have a table like the one I have where certain users can only update some of the fields.

The problem with setting the table to using dynamic update as default is that then other users can't set fields to null without running update statements setting fields specifically to null...

I have searched all over the place, but can't find the answer anywhere...

I would be very happy if somebody could help me out or come up with some thoughts on the subject.