ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ming Xue <ming....@plateau.com>
Subject RE: Custom Tag
Date Thu, 12 May 2005 21:58:56 GMT

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