iBATIS certanly does know that Maps require special handling. However, iBATIS will not do what you're wanting here. This is because iBATIS does not introspect the ResultsetMetaData - which is what would be required in this case. iBATIS only asks for column values out of a resultset that are specifically called out in a resultMap, or that match the setters of a bean in the case of no resultmap.
This seems like a good place to use straight JDBC as you have a requirement that is far beyond the present capabilities of iBATIS. Jeff Butler On 4/25/07, Junyi <[EMAIL PROTECTED]> wrote:
Yes I've done that but it does not work. It doesn't bother filling in the calculations map with anything because iBatis is only looking for getters and setters and doesn't understand a Map requires special handling. On 4/19/07, Larry Meadors <[EMAIL PROTECTED]> wrote: > > Can you eliminate the result map, and use implicit field mapping > instead? > > <select id="getOrderStats" resultClass="SomeClass" remapResults="true"> > select > id, > order, > order_total as total, > $calcColumns$ > from main_orders > where .... etc etc ... > </select> > > Make sure that the constructor for "SomeClass" creates the Map > instance, too - or you'll get an NPE. > > Larry > > > On 4/18/07, Junyi <[EMAIL PROTECTED]> wrote: > > I want to be able to add arbitrary number of calculated columns > (determined > > at runtime) to a query and have those results placed into a Map along > with > > predefined columns. For example, > > > > <resultMap id="someOrder"> > > <result property="id" column="ID"/> > > <result property="order" column="ORDER"/> > > <result property="total" column="ORDER_TOTAL"/> > > <result property="calculations" resultMap="GenericMap"/> > > </resultMap> > > > > <resultMap id="GenericMap" class="Map"/> > > > > <select id="getOrderStats" resultMap="someOrder"> > > select id, order, order_total, $calcColumns$ > > from main_orders > > where .... etc etc ... > > </select> > > > > Using this example, one might pass $calcColumn$ = "total*0.08 as \" > > calculations.tax\", total/quantity as \" calculations.avgcost\"" > > > > This should map all columns with the name "calculations.XXX" into a > Map > > using put(XXX, * ). Currently the code only allows using setXXX( * > ). But > > since Map obviously doesn't have any setter methods, this fails to > populate > > the calculations property. > > > > One ugly workaround requires running 2 queries (one with just > predefined > > columns and the other with the calculated columns) and having Java > match the > > two result sets. Is there any other way without running 2 queries? > I > > tried to send this issue as an iBatis improvement but got > rejected. Thanks. >
