ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michal Bartmanski" <michal.bartman...@star-trac.de>
Subject AW: A quick question need help as ASAP
Date Mon, 17 Jul 2006 13:58:08 GMT

-----Urspr√ľngliche Nachricht-----
Von: Krishnamoorthi, Sruthi (Raytheon)
Gesendet: Montag, 17. Juli 2006 15:56
An: user-java@ibatis.apache.org
Betreff: A quick question need help as ASAP

Hi ,
I need a quick solution for this scenario.
I have a sql where 
<select id="minAsgnmntGateKeeper" resultMap="minAsgnmntGateKeeperRslt">
	select count(ASGMT_SEQUENCE_NO) as countOfAssignments,FK_EMPE_NO  from assignment group by
FK_EMPE_NO order by countOfAssignments asc

My result map is like this

<resultMap id="minAsgnmntGateKeeperRslt" class="java.util.Hashtable">
	<result property="cntOfAssignments" column="countOfAssignments"/>
	<result property="empNo" column="FK_EMPE_NO"/>

This is giving me a mapping exception.

Check the result mapping for the 'cntOfAssignments' property.  
--- Cause: java.sql.SQLException: Invalid column name

When I tried to give the map as 

<resultMap id="minAsgnmntGateKeeperRslt" class="java.util.Hashtable">
	<result property="cntOfAssignments" column="ASGMT_SEQUENCE_NO"/>
	<result property="empNo" column="FK_EMPE_NO"/>

This too gave me the  same error. Could someone provide me a solution to it ASAP.

Sruthi Krishnamoorthi
537 A - (Raytheon) Location 

View raw message