ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric T. Blue" <ericblu...@gmail.com>
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)
Date Wed, 05 Jul 2006 20:55:47 GMT

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 <lmeadors@apache.org> 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

View raw message