Re: Caching resultMap sub-selects

2005-11-05 Thread Michael Campbell
It's in Jira already. I had (mistakenly) just attached the source as the body of the issue, but Clinton removed it in a later revision (I assume(?) he kept the actual source somewhere). He disagreed as to my placement of the code, which might in fact not BE the "right" place, but it works for me.

Re: Caching resultMap sub-selects

2005-11-05 Thread Paul Benedict
Michael, Please submit that as a patch :-) It really bugs me too. I consider this a must have feature of iBATIS. Better developer tools encourages greater use of the product. Paul --- Michael Campbell <[EMAIL PROTECTED]> wrote: > On 11/5/05, Paul Benedict <[EMAIL PROTECTED]> > wrote: > > > Whi

Re: Caching resultMap sub-selects

2005-11-05 Thread Michael Campbell
On 11/5/05, Paul Benedict <[EMAIL PROTECTED]> wrote: > While it is not clear, I think it is recommending to > add a cache to the getProductsByCatId method (not the > parent getCategoryResult). Is that correct? I have > many sub-selects and it makes sense to put the cache > there, the only problem

Caching resultMap sub-selects

2005-11-05 Thread Paul Benedict
For this example: The sqlmap guide says: "The only consideration is that if you were to enable caching, then the using the separate select (not the join) solution could result in a cached instance being returned." While it is not clear, I think it is recommending to add a cache to the g