[ http://nagoya.apache.org/jira/browse/IBATIS-17?page=history ] Clinton Begin reopened IBATIS-17: ---------------------------------
> Generic SQL Map > --------------- > > Key: IBATIS-17 > URL: http://nagoya.apache.org/jira/browse/IBATIS-17 > Project: iBatis for Java > Type: Bug > Components: SQL Maps > Versions: 2.0.8 > Reporter: nilesh > Assignee: Clinton Begin > Priority: Minor > Fix For: 2.0.8 > > I created a generic SQL Map like below. I get a SQL stmt from somewhere and > trying to use iBatis SQLMap just to execute the SQL. I'll provide the > complete select stmt. > <select id="custom_sqlstmt" parameterClass="java.util.HashMap" > resultClass="java.util.HashMap"> > $custom_sql$ > </select> > First call goes thro and comes back with proper results. But when I try to > execute a different SQL using this same SQL Map, it gives me some mapping > exceptions. Looking at the exception, all I can think of is that, sql map > internally keeps the resultset metadata's structure somewhere in the cache > and use the same information again for the subsequent sql calls. In above > case, since I provide a different SQL stmt each time, resultset metadata > would be different per call. And as a result, when sqlmap tries to map the > result using old structure, it throws mapping exceptions. > Is there any work around to resolve this issue? Thanks in advance for your > help! > - Nilesh - -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://nagoya.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
