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
