[ http://issues.apache.org/jira/browse/IBATIS-354?page=all ]
Jeff Butler closed IBATIS-354.
------------------------------
Resolution: Invalid
Not a bug - specify remapResults="true" on your <select>.
Please use the mailing lists for support questions.
> Bug when resultClass is a map in dynamic statement
> --------------------------------------------------
>
> Key: IBATIS-354
> URL: http://issues.apache.org/jira/browse/IBATIS-354
> Project: iBatis for Java
> Issue Type: Bug
> Components: SQL Maps
> Affects Versions: 2.1.7, 2.2.0
> Environment: SUN JDK 1.4.2_10
> Tomcat 5.0.28
> MySQL 5.x
> Reporter: sam zheng
>
> When I want to return a map(HashMap) to temply get a summary result,I catch
> a bug.
> I change my ibatis from 2.1.7 to 2.2.0,the bug is still there.
> I debug it in 2.2.0 with src and found the code seems to reuse the
> resultMappings though the allowRemapping is false.
> -------->
> public ResultMapping[] getResultMappings() {
> if (allowRemapping) {
> return (ResultMapping[]) remappableResultMappings.get();
> } else {
> return resultMappings;
> }
> }
> So when I change my dynamic statement from DAY(summaryType=DAY) to
> MONTH(summaryType=MONTH),the column 'c_day' is not exits now,and then in
> ObjectTypeHandler class,the getResult method want to invoke
> rs.getObject(columnName),execption throw.
> --------->
> public Object getResult(ResultSet rs, String columnName)
> throws SQLException {
> Object object = rs.getObject(columnName);
> if (rs.wasNull()) {
> return null;
> } else {
> return object;
> }
> }
> Exception is :
> ------------------->
> org.apache.jasper.JasperException: Failed to queryForList - id [summary],
> parameterObject [{summaryFor=MEMBER, dateFrom=2006-9-06, summaryType=MONTH,
> dateTo=2006-10-06}]. Cause:
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in com/tuanzi/persistence/sql/Summary.xml.
> --- The error occurred while applying a result map.
> --- Check the summary-AutoResultMap.
> --- Check the result mapping for the 'c_day' property.
> --- Cause: java.sql.SQLException: Column 'c_day' not found.
> Caused by: java.sql.SQLException: Column 'c_day' not found.
>
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>
> com.tuanzi.presentation.base.AccessFilter.doFilterInternal(AccessFilter.java:64)
>
> com.tuanzi.presentation.base.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:59)
>
> com.tuanzi.presentation.base.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:44)
>
> com.tuanzi.presentation.base.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:59)
> My sqlmap config file is :
> -------------------->
> <select id="summary" resultClass="java.util.HashMap"
> parameterClass="java.util.Map">
> <dynamic>
> <isEqual property="summaryType" compareValue="DAY">
> SELECT c_year,c_month,c_day,
> </isEqual>
> <isEqual property="summaryType" compareValue="MONTH">
> SELECT c_year,c_month,
> </isEqual>
> <isEqual property="summaryType" compareValue="YEAR">
> SELECT c_year,
> </isEqual>
> </dynamic>
> sum(c_member_num) as c_member_num,
> sum(c_group_num) as c_group_num,
> sum(c_tip_num) as c_tip_num,
> sum(c_forwar_num) as c_forwar_num
> FROM
> (
> SELECT
> year(c_registertime) as c_year,
> month(c_registertime) as c_month,
> day(c_registertime) as c_day,
> count(*) as c_member_num,
> 0 as c_group_num,
> 0 as c_tip_num,
> 0 as c_forwar_num
> FROM t_memberinfo
> GROUP BY c_year,c_month,c_day
> ) as t
> <dynamic>
> <isEqual property="summaryType" compareValue="DAY">
> <![CDATA[
> WHERE
> (
> c_year>year(#dateFrom#)
> OR
> c_year=year(#dateFrom#) AND c_month>month(#dateFrom#)
> OR
> c_year=year(#dateFrom#) AND c_month=month(#dateFrom#) AND
> c_day>=day(#dateFrom#)
> )
> AND
> (
> c_year<year(#dateTo#)
> OR
> c_year=year(#dateTo#) AND c_month<month(#dateTo#)
> OR
> c_year=year(#dateTo#) AND c_month=month(#dateTo#) AND
> c_day<=day(#dateTo#)
> )
> GROUP BY c_year,c_month,c_day
> ORDER BY c_year,c_month,c_day
> ]]>
> </isEqual>
> <isEqual property="summaryType" compareValue="MONTH">
> <![CDATA[
> WHERE
> (
> c_year>year(#dateFrom#)
> OR
> c_year=year(#dateFrom#) AND c_month>=month(#dateFrom#)
> )
> AND
> (
> c_year<year(#dateTo#)
> OR
> c_year=year(#dateTo#) AND c_month<=month(#dateTo#)
> )
> GROUP BY c_year,c_month
> ORDER BY c_year,c_month
> ]]>
> </isEqual>
> <isEqual property="summaryType" compareValue="YEAR">
> <![CDATA[
> WHERE
> (
> c_year>=year(#dateFrom#)
> )
> AND
> (
> c_year<=year(#dateTo#)
> )
> GROUP BY c_year
> ORDER BY c_year
> ]]>
> </isEqual>
> </dynamic>
> </select>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
