Return-Path: <clinton.begin@gmail.com>
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 37974 invoked by uid 99); 10 Dec 2004 17:18:34 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of clinton.begin@gmail.com
 designates 64.233.184.203 as permitted sender)
Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (64.233.184.203)
  by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 10 Dec 2004 09:18:31 -0800
Received: by wproxy.gmail.com with SMTP id 57so72207wri
        for <ibatis-user-java@incubator.apache.org>;
 Fri, 10 Dec 2004 09:18:22 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references;
        b=qZU7StPC7cUK5q9BlzVzAaUU5wuso/EUNicxiVqunbcs+22wbcyD+sPiCwsAAWNkCuCDDHeFdV1RcqPjzdJ4bL2VORHB8As/D8a+KBAXSiR/JY9FM0ydxZ++ObFa88pP4iwLhavUPBdoDpCo2scL5z5pD5egaT/FWkhfosegnis=
Received: by 10.54.40.1 with SMTP id n1mr953517wrn;
        Fri, 10 Dec 2004 09:17:37 -0800 (PST)
Received: by 10.54.33.19 with HTTP; Fri, 10 Dec 2004 09:17:37 -0800 (PST)
Message-ID: <16178eb104121009174fbc139@mail.gmail.com>
Date: Fri, 10 Dec 2004 10:17:37 -0700
From: Clinton Begin <clinton.begin@gmail.com>
Reply-To: cbegin@ibatis.com
To: "philippe.laflamme" <philippe.laflamme@mail.mcgill.ca>
Subject: Re: Changing result set metadata on the fly.
Cc: ibatis-user-java@incubator.apache.org
In-Reply-To: <003101c4deda$88d00ef0$32edce84@genome.mcgill.ca>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: <16178eb10412100617668b0518@mail.gmail.com>
	 <003101c4deda$88d00ef0$32edce84@genome.mcgill.ca>
X-Virus-Checked: Checked

Actually, my real job is what is taking most of my time.  ;-) 
Luckily, i'm back from Stanford now and I'm hoping to get things
rolling again.

And yes, the incubator has slowed us down quite a bit too.  We're
between worlds right now.  But it's very important that we get iBATIS
into a larger community of developers.  It's too big for me to control
by myself now (especially with a baby on the way).

Finally, to be fair, I didn't say "high" priority, I said "higher"
priority.  Because this was sitting somewhere between "non-issue" and
"low-priority", it's still probably not high.  ;-)

But now that we have a fixed release plan it will be be easier to
identify which features go in when.  We alternate bug-fix releases and
feature releases.  The next one is a feature release.   Hopefully
we'll publish a road map soon.

Cheers,
Clinton





On Fri, 10 Dec 2004 12:06:05 -0500, philippe.laflamme
<philippe.laflamme@mail.mcgill.ca> wrote:
> Just a quick note on the original question... There is a thread in the (now
> closed) iBatis development forum on SourceForge:
> 
> http://sourceforge.net/forum/forum.php?thread_id=1162000&forum_id=206694
> 
> Clinton, you mentioned this would become a high priority issue. Is there any
> update on this? I understand that moving to the incubator must be taking
> most of your time... I'm just curious.
> 
> Thanks,
> Phil
> 
> 
> 
> -----Original Message-----
> From: Clinton Begin [mailto:clinton.begin@gmail.com]
> Sent: December 10, 2004 9:18 AM
> Cc: ibatis-user-java@incubator.apache.org
> Subject: Re: Changing result set metadata on the fly.
> 
> JIRA is not yet the source of record for RFEs.  Not all SourceForge
> resources have made it to the Apache infrastructure yet.  Similarly, CVS is
> not yet in SVN.  These things take time.
> 
> That said, <dynamic> is already a reserved element, and hence this RFE will
> not pass as described.  Perhaps something like <fragmet> or even simply
> <sql> might be more appropriate.
> 
> Cheers,
> Clinton
> 
> On Fri, 10 Dec 2004 08:52:45 -0500, Jerome Jacobsen
> <jerome.jacobsen@gentootech.com> wrote:
> > I submitted a RFE to Sourceforge Tracker back in September that would
> > allow for something similar to what you want.  The RFE ID is 1034260
> > (Named dynamic for reuse).
> >
> > I checked a couple of weeks ago to see if it made it into Jira but it
> > didn't.  I asked the maillist on Nov 30 why it didn't make it but got
> > no response.
> >
> > Anyway, with this RFE your statements would look something like this:
> >
> > <dynamic id="myBigDynamic">
> >
> >
> >  FROM
> >  (
> >    SELECT
> >        rownum as rownumber,
> >        e.emp_employee_id as employeeId,
> >        e.emp_name as employeeName,
> >        e.emp_manager as managerId,
> >        e.manager_name as managerName,
> >        e.muid as managementUnitId,
> >        e.name as managementUnitName,
> >        cS.course_Id as courseId,
> >        cS.course_title as courseTitle,
> >        cS.start_datetime as courseDate,
> >
> >                  cS.module_status_id
> >    FROM
> >        (select
> >            e.emp_employee_id,
> >            e.emp_name,
> >            em.emp_employee_id as emp_manager,
> >            em.emp_name as manager_name,
> >            mu.muid,
> >            mu.name
> >    ..... (lots more)
> > </dynamic>
> >
> > <statement id="getEmployeeAndLastCourseCount">
> >            parameterClass="EmployeeAndLastCourseParam"
> >            resultClass="java.lang.Long">
> >  Select count(*) as count
> >  <dynamic refId="myBigDynamic"/>
> > </statement>
> >
> > <statement id="getEmployeeAndLastCourse"
> >            parameterClass="EmployeeAndLastCourseParam"
> >            resultClass="TrainingRequestListModel">
> >  Select
> >
> >
> >    rownumber,
> >    employeeId,
> >    employeeName,
> >    managerId,
> >    managerName,
> >    managementUnitId,
> >    managementUnitName,
> >    courseId,
> >    courseTitle,
> >    courseDate
> >  <dynamic refId="myBigDynamic"/>
> > </statement>
> >
> > So it is 2 small statements and one large reusable dynamic.
> >
> > -Jerome
> >
> >
> 
>