Obey column order in resultMap ------------------------------ Key: IBATIS-415 URL: https://issues.apache.org/jira/browse/IBATIS-415 Project: iBatis for Java Issue Type: New Feature Components: SQL Maps Affects Versions: 2.3.1 Reporter: Tony Ugando
It will be extremely beneficial if iBatis could lookup column names in a resultSet, in the exact same order they are found in the resultMap. This would allow users to maintain joins much easier, specifically for tables with a lot of columns. Maybe an attribute can be added to the resultMap tag, named obeyColumnOrder="true/false". When setting this attribute to true, then the columns will be read in the exact same order that they are found in the resultMap, and any nested or inherited result maps as well. Currently, it is truly a nightmare when dealing with joined tables that have conflicting column names. You either need to define an alias for each column name, in each table, which is extremely tedious, or you need to use the columnIndex attribute in the result tag. The columnIndex solution is also very tedious to maintain, and it requires you to create multiple resultMaps for each table that you are modeling. eq. select TBL_1.*, TBL_2.* from TBL_1 left outer join TBL_2 on TBL_1.SEQ = TBL_2.FK_SEQ is much easier to maintain than... select TBL_1.SEQ, TBL_1.COL,..., TBL_2.SEQ, TBL_2.COL,... from TBL_1 left outer join TBL_2 on TBL_1.SEQ = TBL_2.FK_SEQ -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.