You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Larry Meadors <lm...@apache.org> on 2006/07/05 22:24:31 UTC
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)
> 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
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)
Posted by Rick <ri...@arc-mind.com>.
I'll take a look.
_____
From: Eric T. Blue [mailto:ericblue76@gmail.com]
Sent: Wednesday, July 05, 2006 1:56 PM
To: user-java@ibatis.apache.org
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 <lm...@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
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)
Posted by "Eric T. Blue" <er...@gmail.com>.
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 <lm...@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
>
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)
Posted by Rick <ri...@arc-mind.com>.
Maybe I'll try the RowHandler first then if that does not work... I'll add
the JIRA request.
I am in JIRA request debt. I found a possible bug the HtmlTree.java
(myfaces) (with a solution) and need to add that as well.
-----Original Message-----
From: Larry Meadors [mailto:lmeadors@apache.org]
Sent: Wednesday, July 05, 2006 1:25 PM
To: user-java@ibatis.apache.org
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)
> 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