Eclipse Community Forums: EclipseLink » How can I query all past versions of an object with eclipselink?..

Home » Eclipse Projects » EclipseLink » How can I query all past versions of an object with eclipselink?..

How can I query all past versions of an object with eclipselink?.. [message #646014]

Tue, 21 December 2010 10:13

Eclipse User

By means of historical session, we can query an object at a specific time. But what I need is to query all the versions of that object..

The documentation points out that we can not do this..How can I
query all previous versions of an object?.

Re: How can I query all past versions of an object with eclipselink?.. [message #646328 is a reply to message #646014]

Thu, 23 December 2010 06:23

Eclipse User

There is no answer. It means that it is not possible.. But with hibernate envers, it is very easy to get this functionality.

Re: How can I query all past versions of an object with eclipselink?.. [message #647150 is a reply to message #646328]

Tue, 04 January 2011 13:43

Eclipse User

There does not seem to be an easy way to do this. Please log an enhancement request and vote for it.

You can use a native SQL query for this. You will need to set "eclipselink.maintain-cache"="true" on the query.

You could also map a separate class to the historical table, and include the start and end date in the object, and the startDate as part of the Id. This is really what you would want to do, as querying the original class will not give you access to the start and end dates. You could use a MappedSuperclass and have the current and historical class subclass it and use the different tables.

Previous Topic:	Lazy load on OneToMany mapping does not work
Next Topic:	CriteriaBuilder aborted

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 02:49:23 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter