While executing HQL query ,will Hibernate use second level cache?

For example

Table : coded_sample

Sno identifier code meaning remarks
1 1001 CC1 coded sample1 sample code
2 1002 CC2 coded sample2 sample code
2 1003 CC3 coded sample2 sample code

entity name is : CodedSample


Second level cache introduced for CodedSample entity.

First and second records are loaded into memory by initial stage(by using load() of Hibernate session). Again I'm executing below query,

HQL : select identifier,code,meaning,remarks from CodedSample where identifier=1001;

Now, whether Hibernate will use second level cache or query hit the DB again?

The results of queries is only served from the cache if the cache is configured as query cache.

See the reference and this Article for details

http://www.devx.com/dbzone/Article/29685

Jens