Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: domain of michael.campbell@gmail.com
 designates 64.233.162.201 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=Ds+dKSwG/B+TZJOiUObs7XWt1+1GA8qdf66cCwd7FDVEIzDXbyTFYKxFC4hu+jV7RlUh7NPv1JZeszd9dhEpvzLQSkToXeSrxldEGmcrZkzIfShs2gR0P1XedE2wETVwXZYMNBd2QoZA+3zMBTTiYytiBV+ZO8hZsnnQJaKt798=
Message-ID: <811f2f1c0511021717v6852820ej4074349a8f90294c@mail.gmail.com>
Date: Wed, 2 Nov 2005 20:17:04 -0500
From: Michael Campbell <michael.campbell@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: Cache w/ Hierarchical ResultMaps
In-Reply-To: <20051103003318.50207.qmail@web32615.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <9430.216.239.124.38.1130952629.squirrel@webmail.sonic.net>
	 <20051103003318.50207.qmail@web32615.mail.mud.yahoo.com>

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 you using ibatis' daos, or rolling your own?

On 11/2/05, Paul Benedict <paul4christ79@yahoo.com> wrote:
> 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
> 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.
>
> I imagine you have standalone queries like findBranch,
> findEmployee, findAddress which lists out their
> respective columns, but then you need to list out all
> those columns again for findVendor?
>
> I am looking for a good methodology here. I know
> Hibernate generates the columns to select
> automatically and I like that because I don't like
> having to tread through multiple sqlmaps just to
> update many select statements when things change.
>
> What is your take on my concern?
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
>


--
I tend to view "truly flexible" by another term: "Make everything
equally hard". -- DHH