invalidating entity bean cache

[auswalk]

Hello, I am not in a clustering environment. Essentially we are doing a JDBC direct update, and afterwards viewing beans which now have dirty data (stale).

I would think the best solution would be to clear the cache for say all entity beans of name "foo". How can this be accomplished?

Thanks

[auswalk]

anyone?

[nraghuram]

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
thanks
raghu

[auswalk]

Argh. I was hoping for something a little more elegant and efficient.

[raja05]

http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=