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




Select * from table1@database2




Select * from table1@database3







I tried to use a sqlmap that states:


<iterate conjuction="UNION ALL">

Select * from table1@#[]#



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!


View raw message