Hi everyone,

I unfortunately have to lauch some SP in my webapp for some heavy data updates.

I'm using ehcache as second level cache.
I'm actually launching the SP with JDBC. So of course ehcache doesn't know about it and my cached persistent objects are getting out of date.

I'm looking for a good elegant way to handle this pb. I know i could use a custom persister but I can't picture how that could solve my problem.

does Spring provides such a feature?

any help /idea is greatly welcome!

thanks,
nodje

Well just evict your objects from the cache after you launched the SP, you know when it happens don't you?

Well, I wish I could have find a way to make HIbernate knows about object updated by an SP.
I realize it was probably hopeless, I don't see anyway for hibernate to catch what is like an "external" data modification.

But using the SessionFactory.evict* method is specified as occuring

So how can I isolate theobjects modified by SP?
Is there any way start a transaction when triggering a SP with JDBC?

Sorry for the newbie's questions, but my knowledge of transactionnal aspects is very fresh and thin.