Re: Recursive Select in SqlMap throws java.sql.SQLException: Exhausted Resultset

Hi dude, I decided to load all nodes (records that satisfies the criteria) using a single select statement and from the results, I loop each record in the list and assign the parent, root and children searching from the list if the related record is there. If the related record is not in the resul

Re: Recursive Select in SqlMap throws java.sql.SQLException: Exhausted Resultset

Thanks for your immediate reply. Hope you could still answer my follow-up queries after each reply you made. On Fri, Feb 27, 2009 at 12:52 AM, Ingmar Lötzsch < iloetz...@asci-systemhaus.de> wrote: > This is the first time I used Ibatis in a project and I'm stucked on this >> error. "Exhausted

Recursive Select in SqlMap throws java.sql.SQLException: Exhausted Resultset

Hi Guys, This is the first time I used Ibatis in a project and I'm stucked on this error. "Exhausted Resultset". My problem started when i designed my model class like the following: class MyObject { private String id; private String parentId; private String rootId; private MyObject r