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: Can we pass entire sql statements to the ibatis framework?
Date Thu, 14 Apr 2005 16:54:10 GMT
yes, use the $myProperty$ syntax.

Brandon

On 4/14/05, Abeyratne, Sam <sam.abeyratne@cingular.com> wrote:
>  
>  
> 
> I have statement that looks like 
> 
>   
> 
> Select * from table1@database1 
> 
>   
> 
> UNION ALL 
> 
>   
> 
> Select * from table1@database2 
> 
>   
> 
> UNION ALL 
> 
>   
> 
> Select * from table1@database3 
> 
>   
> 
> . 
> 
> . 
> 
> . 
> 
>   
> 
>   
> 
> I tried to use a sqlmap that states: 
> 
>   
> 
> <iterate conjuction="UNION ALL"> 
> 
> Select * from table1@#[]# 
> 
> </iterate> 
> 
>   
> 
> Passing a list containing [database1, databaee2, database3, etc] and this
> doesn't seem to work. As I understand this is not possible in the current
> ibatis version. 
> 
>   
> 
> If this is the case, I was wondering if I could make this change in java and
> pass the updated sql to the ibatis framework. Is this possible? How would I
> pass an entire sql statement? 
> 
>   
> 
> Thanks much! 
> 
> Sam

Mime
View raw message