Hibernate 2.1.2
Spring 1.0.1
OsCache
Mysql 4.0

I have a class called Node. It has dynamic-update enabled.

<class
name="project.Node"
table="node"
dynamic-update="true"
dynamic-insert="true"
>

In my unit test I do like this:

Node node = new Node(new Integer(94540));
node.setName("test");
session.saveOrUpdate(node);

I'm expecting the following SQL to be executed:
update nodes set name = test where node_id=94540

But instead this sql is executed:
insert into nodes (name, version, text, etc, etc) values....

What is wrong?


Here's the debug info:

I'm currently looking into optimistic locking and forgot to set the version number.

So if I do like this an SQL update is executed.
node.setVersion(new Integer(16));
node.setName("test");

But I still have the problem with dynamic-update.

Hibernate executes this:
update nodes set name=?, version=?, text=?, etc, etc

But I'm expecting it to update just the two columns I updated.
update nodes set name=?, version=?

you do not have to set the version number.

looks like you have some broken get/set pairs.

I'm building a webapplication so I have a version field on the form that is used to edit the node object.



If I don't set the version how would Hibernate know the version of the edited object? Or are you not allowed to call setVersion ever?

Should I do manual version checking instead?

If you map a property with the <version> tag, Hibernate manages the version number.

I'm using the version number tag.



Could you explain if my approach to versioning is correct in a webapplication.
Or even better how you would do it.

And when not setting the version number I get a NPE.

your unsaved-value mapping is incorrect, or you have a broken get/set pair

I fixed the mapping by specifying java.lang.Integer as type for the version.

But I still have the problem with dynamic-update. I just set the value of one column but still it tries to update or insert the values of all columns.

dynamic-update does not affect what happens in the case of update(), unless select-before-update is enabled. Think about it!

I will do the version checks manually like in option three in the documentation:
http://www.hibernate.org/hib_docs/refer ... optimistic

I thought Hibernate would do it automatically but I guess not. At least with my configuration.

huh??

of course hibernate does it automatically

Could you please explain how? If you're developing a webapplication how would you do it.

emmanuel described a solution here http://forum.hibernate.org/viewtopic.php?t=928177 and I'm trying to get it to work. Without any luck.