We are looking for a pain-free way to add query-able, historical information concerning the changes in our database. Oracle 11g has a product called Total Recall which will do this behind the scenes for us, but retrieving this historical data requires some non-standard SQL extensions, e.g., the "AS OF ..." clause below:
Code:
SELECT LAST_NAME, FIRST_NAME, SALARY
FROM EMPLOYEES AS OF TIMESTAMP TO_TIMESTAMP ('2007-02-03 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
WHERE empoyee_id=193;
Is there any support for this in Hibernate? If not, what would be involved in adding it?
Login
FAQ
Search