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