Bulk deletion affecting cache where

amy

Say there is a table A.

Lets delete some entries:Code:
delete from A where A.a = :b
What happens in the 2nd level cache ?

Does/should a JPA provider handle the caching issues properly ?

According to the spec (4.10) even the 1st level cache (the persistence context) isn't affected by a bulk operation so I'm pretty sure the 2nd level cache isn't neither.
I'm calling Cache.evict(..) after any bulk operation to remove those entities from the 2nd level cache.

Robin.