updating individual columns

blackDoggy · **Joined:** Thu Feb 05, 2004 9:32 am **Posts:** 7

Hello,

I would like to update individual properties of an object, like UPDATE employees SET name='John' for an employee. I can't use 'update=false' attribute for the property as I want my users to choose which property to update. How to do this in Hibernate?

I would really appreciate any comments or ideas.

Best regards,
John

christian · **Posted:** Thu Feb 05, 2004 9:50 am

Don't know exactly what you want to do, but...

If you set dynamic-update="true" on your class, only changed properties will be updated at flush. This prevents Hibernate from generating the standard CRUD SQL for that class on startup, it is then generated at runtime.

blackDoggy · **Joined:** Thu Feb 05, 2004 9:32 am **Posts:** 7

I have a large table with a lot of columns. Usually I only want to update some of them, but I can't know in advance, which.

I assume that when using 'dynamic-update=true', I would have to update like this:

Code:

session.load(myObject)
myObject.setSomething('value');
session.flush();

The problem is that I can't load the object before updating as it's very big, and contains BLOBS, and therefore would create a lot of uneeded database traffic.

christian · **Posted:** Thu Feb 05, 2004 10:04 am

LOBs are lazily loaded, and you can also lazy load all associations. This should be OK, otherwise Hibernate (and almost all other O/R mapping tools) is not the right tool for this use case. You can get a JDBC connection from the Session if you need it.

blackDoggy · **Joined:** Thu Feb 05, 2004 9:32 am **Posts:** 7

Thanks ;)