ibatis decorater pattern

[Josh Joy <jo...@gmail.com>]

Hi,

I've seen and used the ability to have sql fragements, though is there a
sort of sql fragment decorater that I can do?

here is an quick simple example

<sql id="pagination">

select * from
    (
         select Row_Number(),  !somesql!
    ) a
where RowNum > 1

</sql>


<select id="myquery">
      <decorate refid="pagination">
            select * from sometable
     </decorate>
</select>



The alternative would be to split it into a header/footer and include for
each query, though would be convenient if there was some sort of decorater.

Thanks,
Josh