Loading records from versioned tables

a.santini · **Joined:** Tue Mar 30, 2004 6:52 am **Posts:** 2

Hibernate 2.1.2

Is there a way to automatically read the latest version of a record. I have the following mapping excerpt:

...
<id name="number" column="PROPNUM" type="java.lang.String"/>
<generator class="assigned"/>
</id>
<version name="version" type="long" column="VERSIONNUM" />
...

is it possible using Session.get(), Session.load() or similars.

emmanuel · **Posted:** Wed Mar 31, 2004 9:47 am

There cannot be different versions of the same object in the table. This column is only here to keep track of the last version, not to keep track of all the versions.

a.santini · **Joined:** Tue Mar 30, 2004 6:52 am **Posts:** 2

emmanuel wrote:

There cannot be different versions of the same object in the table. This column is only here to keep track of the last version, not to keep track of all the versions.

Thanks. So if I have a table which stores all the versions of a record I have to create a composite ID (UID,version). Is it?

emmanuel · **Posted:** Wed Mar 31, 2004 10:18 am

Correct, and thus don't use <version> tag, I don't think it is intended to be used in your case.