[jira] Closed: (IBATIS-577) Ibator: Define column list as 'sql' fragment for better reusability.

["Jeff Butler (JIRA)" <ib...@incubator.apache.org>]

     [ https://issues.apache.org/jira/browse/IBATIS-577?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jeff Butler closed IBATIS-577.
------------------------------

    Resolution: Fixed

Fixed in SVN.

Thanks for the idea!


> Ibator: Define column list as 'sql' fragment for better reusability.
> --------------------------------------------------------------------
>
>                 Key: IBATIS-577
>                 URL: https://issues.apache.org/jira/browse/IBATIS-577
>             Project: iBatis for Java
>          Issue Type: Improvement
>          Components: Tools
>            Reporter: Iwao AVE!
>            Assignee: Jeff Butler
>            Priority: Minor
>         Attachments: IBATIS-577.patch
>
>
> So, it would look like...
> <sql id="ibatorgenerated_columnsWithBLOBs">
>   column_a, column_b, column_c
> </sql>
> <select id="ibatorgenerated_selectByExample" parameterClass="xxx" resultMap="ibatorgenerated_BaseResultMap">
>   select 
>   <include refid="table_name.ibatorgenerated_ColumnsWithoutBLOBs" />
>   from table_name
>   ...
> Then, when I add a new custom query, I can write as follows.
> <resultMap id="custom_resultMap" ...>
>   <result property="table_name" resultMap="table_name.ibatorgenerated_BaseResultMap" />
>   <result property="another_table_name" resultMap="another_table_name.ibatorgenerated_BaseResultMap" />
> </resultMap>
> <select id="custom_selectByExample" ...>
>   select
>   <include refid="table_name.ibatorgenerated_ColumnsWithoutBLOBs" />
>   ,
>   <include refid="another_table_name.ibatorgenerated_ColumnsWithoutBLOBs" />
>   from table_name
>   left join another_table_name on ....
>   ...
> </select>
> This would save us from modifying sqlmap manually when a new column is added to a table, for example.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.