Thanks it works perfectly.
I have one more question on namespaces.
My sqlmap1 has namespace "Name", so I first assumed that any SELECT
will be combined to have it.
eg: a select like:
<select id="Select" ...
is inedeed recognized
<select id="Name.Select"
but this thorw an error on second Namemap, that complaints the select
id is already in use.
On the other side i have added the CacheModel namespace
cacheModel="CacheModels.NameCache" and this seems to be combined
automatically.
My cachemodel map is indeed:
<sqlMap
namespace="CacheModels"
xmlns="http://ibatis.apache.org/mapping";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
>
<cacheModels>
<cacheModel id="NameCache" implementation="LRU">
Why on cache namespace is added and on select is not added?
Thanks
Manu
On 9/25/05, Ron Grabowski <[EMAIL PROTECTED]> wrote:
> 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
> >
>
>
