Is it possible to achieve this using Hibernate?

I have Orders table in which the status can be P, A, B, M, G, X

There is a JSP application which fetches the orders
Two links -
Orders with pending status (gives all orders with status='P')
Orders with confirmed status(gives all orders with status<>'P')

Is there anyway to cache the contents of the second query and never the first query? This is because once the order is confirmed, its entries cannot change(for some tables like orders, orderitems etc)

You can write two separate queries for these and use query cache for the one you want to cache.