|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
| James Sutherland
Registered: July 2009
Location: Ottawa, Canada
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.
James : Wiki : Book : Blog : Twitter
Powered by FUDForum
. Page generated in 0.07152 seconds