Our database object has an autogenerated primary key along with other alternate unique keys. We use the hibernate second-level cache for these objects, but most often we are looking up by the alternate unique keys and the second level cache does not help for these situations. We would enable the query cache, but our queries use an in clause and take an array of alternate unique keys. This array of keys will almost never be the same and hence we will never get a query cache hit. Is it possible to tell the hibernate second level cache to cache by alternate unique keys in addition to the primary key?

Thanks.

-karl