Hi Guru,

Flashback query is introduced in the oracle 10g, which handles the historical and temporal dimension of data out of box, each flashback query comes with "as of timestamp" clause, which returns version of data made to the database over the time at row level.

I can use the native sql query with "as of" in the hibernate, but it is clumsy, and a lot of hibernate functions are not used, it is obviously not a good approach.

I would like to know if there is a way of extending/customizing hibernate to support the oracle flashback query, which means that all the queries generated by hibernate comes with "as of timestamp" (either the timestamp is current time or past time) based on parameter of timestamp.
e.g I can load a object with timestamp, when I retrieve the array of objects from the object loaded with timestamp, the array of objects is also the version of data based on the parent object's timestamp as well, etc.


I appreciate it if anyone can shed light on it!

Thanks in advance!

xm