Re: (tangent) Cache w/ Hierarchical ResultMaps

2005-11-02 Thread Paul Benedict
Larry, My other option is to say "heck with solving the N+1 problem!" and turn my nested resultMaps into nested selects. For each object, execute N selects for N inner objects it would sure clean up my code! Man, I feel so alone here LOL I am sorry no one else has really complex queries which

Re: (tangent) Cache w/ Hierarchical ResultMaps

2005-11-02 Thread Larry Meadors
On 11/2/05, Paul Benedict <[EMAIL PROTECTED]> wrote: > I could use iBATIS and Hibernate side by side, but > that would be an odd combination. I have to confess that I was involved in a project that did just that. For the love of all that is good and right in the universe, don't do it. It was *th

Re: (tangent) Cache w/ Hierarchical ResultMaps

2005-11-02 Thread Paul Benedict
So does the iBATIS community recommend I turn to Hibernate for my kind of situation? Oh, my poor code - torn between loves :-) I loved everything about iBATIS until I had to eagerly retrieve complex inner objects using JOINs. Please inform me if iBATIS offers any good solution to my problem. I coul

Re: (tangent) Cache w/ Hierarchical ResultMaps

2005-11-02 Thread reuben
Paul Benedict wrote: I am in the same situation (see my posts about my Fruit object). I am curious about how you feel about needing to list out, if you do, all your columns for those 4 objects to retrieve a Vendor. This assumes you're not doing 4 selects, but one select using joins. Hi Paul,

Re: Cache w/ Hierarchical ResultMaps

2005-11-02 Thread Paul Benedict
I have a DAO interface which is implemented by a subclass of Spring's SqlMapClientDaoSupport --- Michael Campbell <[EMAIL PROTECTED]> wrote: > Just a general note here... not every tool is > suitable for every project. > iBatis solves a very LARGE set of needs, but it > might be that it just > d

Re: Cache w/ Hierarchical ResultMaps

2005-11-02 Thread Michael Campbell
Just a general note here... not every tool is suitable for every project. iBatis solves a very LARGE set of needs, but it might be that it just doesn't solve THIS one (it might, but it's sounding like not...) Good luck in any case, and I wish I had a nifty solution for you. Out of curiosity, are

Re: Cache w/ Hierarchical ResultMaps

2005-11-02 Thread Paul Benedict
Reuben (I hope that's your first name :-)), >> Vendor / Branch / Employee / Address >> When I load a Vendor, I wish (if at all possible) to load it from the cache, since it contains all sub objects (Branch, Employee, Address), and is rather big. I am in the same situation (see my posts about my F

Re: Cache w/ Hierarchical ResultMaps

2005-11-02 Thread reubenf
Hi Clinton, this is actually use case based. Let me put *example* names to my tables to illustrate: Vendor / Branch / Employee / Address When I load a Vendor, I wish (if at all possible) to load it from the cache, since it contains all sub objects (Branch, Employee, Address), and is rather big.

Re: Cache w/ Hierarchical ResultMaps

2005-11-02 Thread Clinton Begin
I would suggest to avoid building cache models of that complexity.  Remember, cache models are not intended to be associated with result maps, nor dependencies based on result map configurations. iBATIS cache models are statement (a.k.a. use case) based, not object id (a.k.a. holistic) caches. 

Cache w/ Hierarchical ResultMaps

2005-10-26 Thread reubenf
Hello, I found that the cache doesn't behave exactly as I'd have expected; I'm using an LRU cache. Is there a way that I can configure it to behave as I'd like? I have a hierarchical object tree, mapped using ResultMaps: ... ... I am caching A. It looks like all of the Bs that belong to A