I’ll take a look.
From: Eric T. Blue
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 05, 2006
1:56 PM
To: [email protected]
Subject: Re: No tree support in
iBatis RE: It worked (kinda) RE: One solution to self-join, new feature
request.... RE: Employee self-join one to many relationship (iBatis)
Rick,
For what it's worth, I also tried building a tree a while ago using a combo of
SQL and abstracting some code in the DAO (No RowHandler or anything like
that). Because some of these trees were going to be potentially very
large (a couple hundred thousand items), and I was not using a cache-model I
opted to do this in code. I basically execute a single query to return a
List of objects, each containing an id and parent id property. Then I
used the Jenkov TreeTag library ( http://java-source.net/open-source/jsp-tag-libraries/prize-tags)
to iterate over the collection and build the tree. This is primarily used
for building trees in JSP, but you can use the public API just fine.
P.S. It looks like the jenkov.com site is down
right now. But if you're interested in some sample code I'd be more than
happy to mail off-list.
On 7/5/06, Larry
Meadors <[EMAIL PROTECTED]>
wrote:
> It seems like dealing with trees is a fairly common case, so this
could be
> generalized and put into iBatis.
IMO, I think you should add it so we have a reminder of it...even if
we never implement it.
I wonder if a RowHandler implementation would be faster. I guess if
you are bored you could try that, too. ;-)
Larry
|
