Re: Cache entry invalidation on updates

2005-05-22 Thread Brandon Goodin
The iBatis caching key is based on the SQL query that is sent to the database. The full results are cached under that key in the particular specified CacheModel. It does not retain the individual object dentity (OID) of all the individual objects returned in a query. This means that if you have an

Cache entry invalidation on updates

2005-05-22 Thread Oscar Picasso
Is there a way to invalidate a cache entry on update? Let say I have the following select using a cache model (result class = User): select id, username, password from users where useraname = #username#; and the following update (parameter class = User): update users set password = #password# w