Why can Hibernate's query cache be less effective than expected on a frequently-written table?

The query cache invalidates at the table level, not the row level — ANY write to a table involved in a cached query invalidates every cached query result touching that table, regardless of whether the specific rows a given cached query returned were actually affected by that write.