Re: ResultMap columns as a superset of select columns

2008-09-25 Thread Sundar Sankar
If you carefully design your resultmaps, the "extends" property of the result map could help you. The only precaution you might have to take is that, The order of declaration should be the order of definition in the sqlmap file. On Thu, Sep 25, 2008 at 4:11 PM, Daniel Henrique Alves Lima < [EMAI

RE: ResultMap columns as a superset of select columns

2008-09-25 Thread Daniel Henrique Alves Lima
I'm trying to re-use the same ResultMap multiple times, but in the second query (with one column) the JDBC driver will raise an exception because "nm_entity" does not exist in the returned ResultSet. I want to avoid to define a lot of ResultMaps for the same table... Is there an wa

RE: ResultMap columns as a superset of select columns

2008-09-25 Thread Shannon, Bryan
You can alias your columns in your select. Select foo as cd_entity, bar as nm_entity from table iBatis will use the alias to map the results in the resultMap. -Original Message- From: Daniel Henrique Alves Lima [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2008 2:32 PM To: u