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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]
> 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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]
> > 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 <[EMAIL PROTECTED]> 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?
> > >
> > >
> >
> >
>
