Hellu,

I have a User class that has collection of addresses that are contained in another table (as Valuetype objects).

I always need the latest address, that he is currently living. The address has a startDate and endDate property. The latter one is null for the current address he is living.

I would like to add a property in the User object called currentAddress, that always contains the latest address object and is managed by Hibernate, and is able to cascade.

Please some advice on how to do this ?

I tried several options,,.. but can't figger it out :(...

yes it is possible using formula.

here is example described:

http://www.onjava.com/pub/a/onjava/2005 ... tml?page=3

but dont forget that this will always cause one extra select for loading User

Thanks Ferozz, I will have a look at it