I have the following scenario :

table Car has 5 colums
1) id (PK)
2) name
3) speed
4) mileage
5) price

In my DAO I do something like :

Car c = new Car(); ( I am not loading this object from database)
car.setId(1);
car.setName("test");
session.update(car);

Is there a way to update only the name field instead of updating all the columns?

Thanks.

I have not done this to entities that did not come from the database to begin with, but maybe the following may work.

First, you have to set <class ... dynamic-update="true"> for your Car class.
Then try the following:



The call to Session.lock() should set the "zero"-point for your Car object. Everything you do to it after that is detected and the dynamic-update="true" setting should make sure that only changed values are sent to the database.

You might also simply consider doing a HQL UPDATE query:

hi,

that works like a charm :) ...yeah right now I am firing a direct update sql for this ... but the number of fields that will be changed is going to be dynamic ..