How to use simple jdbc Statement in ibatis

[Tamilselvan Radha Krishnan <Ta...@igate.com>]

Hi,
Is it possible to form a SQL Query like JDBC Statement  in ibatis?  I
need to select a column value that is same across most tables, for
example LAST_UPDATED_USER.
My requirement is that whenever I require the LAST_UPDATED_USER from a
specific table, a single method should accept the query and execute the
result.

Regards

Tamil

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Information transmitted by this EMAIL is proprietary to iGATE Group of Companies and is intended for use only by the individual 
or entity to whom it is addressed and may contain information that is privileged, confidential, or exempt from disclosure under 
applicable law. If you are not the intended recipient of this EMAIL immediately notify the sender at iGATE or mailadmin@igate.com 
and delete this EMAIL including any attachments
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Re: How to use simple jdbc Statement in ibatis

[Koka Kiknadze <22...@gmail.com>]

I think you should look at remapResults paragraph in dev guide and use
something like

select LAST_UPDATED_USER  from $sometable$

Now the string passed to your single DAO method will be substituted for
$sometable$