So, how I can update only what changes and is not null ? In the case of a not null field, to normal fields the update works fine...

For an example, I have one entity...

Client: code(key), name, street,number,dateSave(the date that this client is saved in the system...)

So the dateSave field is saved only in the SAVE method, and it never change. But when I try to perform one Session.update call on a client row, I get the follow error.



The work arround that I use to perform this behavior is to programaticly create one UPDATE HQL Query to update my registry. This works fine but it seems that it is not the best aproach =/

How can I do this with a simple call to Session.update ? Exists any mapping property that I can set to perform this behavior ?

Thanks in advance.
Rodrigo Kerkhoff

What you need to do is use Hibernate to load the entity from the database into your program. Update that loaded entity, and then commit your transaction. The data will be updated without worrying about any null values.

This is the unique work arround for this problem ?

The system that I´m developing will be accessed in all country, so, this 'SELECT' before update would be a performance problem I think... am I wrong ?

Because the system will be acessed by +- 2000 peoples simultaneously....

Off course, this peoples doesnt go to perform updates like this every time....

I just want to know if this is the unique solution that I have....

Thanks for the reply..

Rodrigo Kerkhoff