One possible solution
Write a finder ejb-ql to return all the entities matching your criteria.
write a dummy method in the entity bean which throws a non-application exception. this will invalidate the cached instance
You could do these after you execute the update sql.
If you find a better solution pls post it
Argh. I was hoping for something a little more elegant and efficient.