Hi, I'm having trouble doing something that seems like it would be easy with hibernate. Basically, I am caching a view from my database. Each row in the view is represented by a rowDto pojo object. When I load this view into the cache with hibernate I get a List of rowDto objects for every row in the table. Up until now everything is working as expected.

However, there are many times in my code in which I want to retrieve different results from this list. For example, only the rows where rowDto.columnA = 100. The only way I can get this to work is adding the constraint to the where clause and querying the database again. This is a big performance hit. Since I have the whole view cached it seems I should just be able to query the cache with different constraints. I have been searching on this for some time and can't find what I need. Does hibernate not have this functionality? If it does, can someone point me in the right direction?

Thanks.

You are free to traverse your cached collection with Java code in order to achieve what you want.
But, in principle, Hibernate is a layer of persistence against the database, not a collections API.
In other words: no, Hibernate cannot take advantage of the fact that you have all the collection cached.