I would like to know if the following is possible to achieve using query cache mechanism.
Being a fresher to Hibernate, I understood the basic purpose of using query cache, ie, to fetch the data from the cache instead of fetching from the DB each and every time which increases the performance.
My requirement is as follows- I fetch a set of 10 records from the DB and cache them using query cache and second-level cache. Now, would it be possible to fetch next or previous set of 10 records using already cached identifier values? If possible, could you please let me know how it can be achieved? If not, is there any other means to achieve this?
Thanks in advance!! [ May 10, 2007: Message edited by: deepa gr ]