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?
> >
> >
>
>
