[
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.
