Hi Phillipe,Clinton Thanks for taking time to answering my queries.
Navin --- Clinton Begin <[EMAIL PROTECTED]> wrote: > Come to think of it, why don't you go ahead and > submit it to JIRA? > It's not like I'd be doing anything different > (there's no migration > tool). ;-) > > This way it's tracked under your name too. > > Cheers, > Clinton > > > On Fri, 10 Dec 2004 12:06:05 -0500, > philippe.laflamme > <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > > Sent: December 10, 2004 9:18 AM > > Cc: [EMAIL PROTECTED] > > 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 > > <[EMAIL PROTECTED]> 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 > > > > > > > > > > > __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail
