Hibernate only fetching the last in from an object's collection and not the whole collection?

[David Rocks]

Is this possible?

I have an object that holds a collection (a large one).

	
                @OneToMany( mappedBy="topic" )
	@OrderBy( "id DESC" ) 
	private List<TopicVersion> topicVersions  ;	

I am only interested in the last object in ( PK will be max ) is there a way to get a collection containing only the last one in or a way to have an single object that is populated with the last one in using annotations?

Thanks in advance for any help.

[Hebert Coelho]

Annotations I do not think so, You could use a NamedQuery instead.

[David Rocks]

Checking the docs I think I max be able to do it using

@BAtchSize and setting up and @OrderBy to return last first.

[Hebert Coelho]

Be aware that every time you call the collections, it will come with the same results. If you want to see all the results you would need to create a new attribute or use a query.