Can some one please let me know what would be the issue? Thanks, Kiran
--- On Mon, 8/18/08, kiran vuppla <[EMAIL PROTECTED]> wrote: From: kiran vuppla <[EMAIL PROTECTED]> Subject: Invalid Column Name error To: "iBatis Forum" <[email protected]> Date: Monday, August 18, 2008, 7:43 PM I am getting the following error, I will appreciate if some can let me know what is the issue. Thanks in Advance. --- The error occurred while applying a result map. --- Check the merchant.getMaxValue. --- Check the result mapping for the 'max' property. --- Cause: java.sql.SQLException: Invalid column name at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298) at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209) ... 72 more <resultMap id="DistributionResult" class="Distribution"> <result property="totalProducts" column="TOTAL_PRODUCTS"/> <result property="totalAmt" column="TOTAL_AMT"/> <result property="merchant.id" column="TERM_ID"/> <result property="max" column="{merchantId = TERM_ID,#merchants#,#startDate#,#endDate#}" select="merchant.getMaxValue"/> </resultMap> <select id="getDistribution" parameterClass="map" resultMap="DistributionResult"> SELECT COUNT(*) as TOTAL_PRODUCTS , SUM(a.amount) as TOTAL_AMT , A.TERMID as TERM_ID FROM tbl a, tbl b WHERE a.termid = b.id <iterate property="merchants" open=" and a.SATHCDHACCTKEY in (" close = ")" conjunction=","> #merchants[]# </iterate> AND a.dtathdate BETWEEN #startDate# AND #endDate# group by A.TERMID </select> <select id="getMaxVALue" resultClass="int"> SELECT MAX(subTbl.cnt1) as value from (SELECT COUNT(A.KEY ) as cnt1 FROM ath a, merchantterminal m WHERE A.SATHTERMID = M.LID and M.LID = #merchantId# <iterate property="merchants" open=" and a.KEY in (" close = ")" conjunction=","> #merchants[]# </iterate> AND a.dtathdate BETWEEN #startDate# AND #endDate# group by to_char(a.dtathdate,'YYYYMMDD') ) subTbl </select> Thanks Kiran
