A quick question need help as ASAP

["Krishnamoorthi, Sruthi (Raytheon)" <Sr...@USPTO.GOV>]

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
</select>

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"/>
</resultMap>

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"/>
</resultMap>

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


Thanks,
Sruthi Krishnamoorthi
703-562-9732(Work)
537 A - (Raytheon) Location 

RE: A quick question need help as ASAP

[jaybytez <ja...@gmail.com>]

This original posting was "Selling iBatis to skeptics".  Instead of creating
a new post on your specific topic...it appears you have replied to "Selling
iBatis to skeptics" with a totally different topic.  Therefore totally
confusing the original topic and possibly stopping posts on what I was
originally trying to find out.
-- 
View this message in context: http://www.nabble.com/Selling-iBatis-to-the-skeptics-tf1945597.html#a5365713
Sent from the iBATIS - User - Java forum at Nabble.com.

Re: A quick question need help as ASAP

[jaybytez <ja...@gmail.com>]

Um...did you create your own posting inregards to your question...

Looks like you jumped on the wrong topic.
-- 
View this message in context: http://www.nabble.com/Selling-iBatis-to-the-skeptics-tf1945597.html#a5364858
Sent from the iBATIS - User - Java forum at Nabble.com.