ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kevin <kevin_...@yahoo.com>
Subject Re: Changing result set metadata on the fly.
Date Mon, 13 Dec 2004 05:55:59 GMT

Hi Phillipe,Clinton

Thanks for taking time to answering my queries.

Navin


--- Clinton Begin <clinton.begin@gmail.com> 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
> <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
> > >
> > >
> > 
> >
> 



	
		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - You care about security. So do we. 
http://promotions.yahoo.com/new_mail

Mime
View raw message