Will hibernate second level cache refresh itself if there is a change in the data of any of the database tables?

I understand that the second level cache will not be used if i have a select query not based on primary key. How do i make use of the second level cache for custom queries?

Example
Table1

ID (Primary Key) Name
1 x
2 y
3 z


the following hql query
"from table1 where name='x'" will hit the database everytime i execute it right?

i want to be able to get the results from the cache from the same query if i execute it the second time...i know there is query cache...but will the query cache work well when there is a change in the data?

Please help

How would the cache know the DB has been updated? You can, however, set the cache provider to expire data after a period of time. Or flush the cache yourself.

i though hibernate has a mechanism to read some kind of a db statistics on tables to detect if there is any change and refresh the cache accordingly