You can do something like:
<select id="someStatementName" remapResults="true"
parameterClass="java.util.Map" resultMap="someResultMap">
<![CDATA[
select * from $RuleTable$ where RULE_ACTIVE=1
]]>
</select>
Then just treat "RuleTable as any other parameter you need to set.
Notice the remapResults="true" is required.
On Thu, 10 Mar 2005 19:42:58 -0800, Rajiv Kumar <[EMAIL PROTECTED]> wrote:
>
>
> Hello,
>
> I have very simple select statement
> select * from Level_1_Rules where RULE_ACTIVE=1
>
> All I want to do is qualify table name with schema name.
>
> For every run of my program this schema name is different.
>
>
> Regards,
> Rajiv Kumar
