ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abeyratne, Sam" <sam.abeyra...@cingular.com>
Subject Can we pass entire sql statements to the ibatis framework?
Date Thu, 14 Apr 2005 16:48:59 GMT
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