How to evict know out of date objects (after SQL statement)

[mvera]

Hi,

I intend to use jbosscache as level 2 cache with EJB entites.

Cache evictions are done only when a modification occurs inside the EntityManager.

But for performances reasons it may be usefull to send SQL statements that modify database, for example you may want to delete hundreds of objects in a single SQL statement instead of getting all objects iterate over them. Update of objects is also possible.

Suppose I know (in the same transaction) which objects are modified or deleted. Is there any way to send this list to JbossCache ?

If this is not possible, what is the solution ? Is it possible to use cache level 2 with entities when databse is modified outside of the entity manager ?

Mickaël

[manik]

Hmm, AFAIK it is generally frowned upon to directly modify the database when using JPA/EJB3 Entities/Hibernate/ORM frameworks in general.

I'm not a JPA/EJB3 Entity expert, but surely bulk updates are supported in EJB-QL?

[brian.stansberry]

Yes, they are, and if you use them Hibernate will invalidate the relevant regions of the 2nd level cache.