ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Goodin <brandon.goo...@gmail.com>
Subject Re: Custom Tag
Date Thu, 12 May 2005 22:09:14 GMT
I see. The question here is whether this is a common database issue
and if it should be supported. However, it does not seem to be a
common issue and there are ways to work around this. My other thought
is.... why do you have over 250+ IN parameters? Maybe you need to
rethink what you are developing. There would seem to be a reson why
there is a 250 cap. Go ahead and drop an enhancement request into
JIRA. We'll consider this in the next major release.

Brandon

On 5/12/05, Ming Xue <ming.xue@plateau.com> wrote:
> 
> The Oralce in list limition is 250,  otherwise the sql can not be parsed,
> For example:
> 
> select * from abc
> where a in ('a', 'b', 'c', ...)
> 
> if there are more than 250 values in the in list, the sql needs to be
> rewritten as:
> 
> select * from abc
> where a in ('a', 'b', 'c'...)
> or a in ('x', 'y', 'z'...)
> or ...
> 
> In this way every inlist is less than 250
> 
> The Iterate tag is designed for generating the in-list, for it is not aware
> of the Oracle limitation, so is there anyway I can modify the existing
> <iterate> tag or creating a new one?
> 
> Thanks
> 
> 
> -----Original Message-----
> From: Brandon Goodin [mailto:brandon.goodin@gmail.com]
> Sent: Thursday, May 12, 2005 5:40 PM
> To: ibatis-user-java@incubator.apache.org
> Subject: Re: Custom Tag
> 
> That is not a clear example. I'm not sure what the problem is that you
> are presenting. What tag would you write to accomplish a solution to
> the problem you are presenting?
> 
> If you are referring to the population of an IN statement then you
> could use <iterate>.
> 
> Brandon
> 
> On 5/12/05, Ming Xue <ming.xue@plateau.com> wrote:
> >
> > For example,   for Oracle in list limitation while using
> >
> > select * from abc
> > where a in ('a', 'b', 'c', ...)
> >
> > We need to use a Custom tag for this.
> >
> > Thanks
> >
> >
> > -----Original Message-----
> > From: Larry Meadors [mailto:larry.meadors@gmail.com]
> > Sent: Thursday, May 12, 2005 5:21 PM
> > To: ibatis-user-java@incubator.apache.org
> > Subject: Re: Custom Tag
> >
> > A couple?
> >
> > Check again.
> >
> > That is an interesting idea though.
> >
> > Larry
> >
> > PS: Please do not reply to other posts with new topics.
> >
> >
> > On 5/12/05, Ming Xue <ming.xue@plateau.com> wrote:
> > >
> > > Hi
> > >
> > > I am very much amazed by Ibatis's ability to generate dynamic sql, which
> > is blank in Hibernate.  There are a couple predefined tags provided by
> > default,  But,  does the framework support  Custom Tags? if so, how can I
> > attched them to the FrameWork?
> > >
> > >
> >
> >
>

Mime
View raw message