To reference a cache model or a statement in another sqlMap file, turn on namespaces and use the full namespace of the item.
The code in SVN allows a sqlMap to contain just a cacheModels node: <?xml version="1.0" encoding="UTF-8" ?> <sqlMap namespace="CacheModels" xmlns="http://ibatis.apache.org/mapping"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> <cacheModels> <cacheModel id="UserCache" implementation="MEMORY"> <property name="Type" value="Strong" /> <flushInterval hours="2" /> <flushOnExecute statement="User.Insert" /> <flushOnExecute statement="User.Update" /> <flushOnExecute statement="User.Delete" /> </cacheModel> </cacheModels> </sqlMap> The code in SVN also delays associating cacheModels with statements until all statements have been processed so you can include your cacheModel sqlMap file before or after your other sqlMap files. --- Emmanuele De Andreis <[EMAIL PROTECTED]> wrote: > HI all, > I have 2 sqlmaps that use LRU cache. > > Now sqlmap1 work fine. > Cache is used for SELECT and invalidated on INSERT, UPDATE, DELETE > > The sqlmap2 should be cached too but since uses an inner join with > table in sql map1 too should be invaldated when sqlmap1 is INSERT, > UPDATE, DELETE > > So how I can Invalidate a cache in one sqlmap from another sql map? > Is there a way to refer to a differente map? > Is there a way to actually define all caches in a separate config > file? > > I'm using SVN code and Vstudio 2005 > > Thanks > > Manu >
