JDBCTemplate QueryForList returns wrong value

http://www.coderanch.com/t/559054/Spring/JDBCTemplate-QueryForList-returns-wrong

JDBCTemplate QueryForList returns wrong value

 

Hi all,  I have the following code...  view plain print ? Note: Text content in the code blocks is automatically word-wrapped String GET_AGENTS_FOR_CYCLE = "select AGENTSURROGATECODE from SETTLEMENT.AGENT_DETAILS where CYCLE = ?";   List agentsList = jdbcTemplate.queryForList(GET_AGENTS_FOR_CYCLE,                   new Object [] {getCycle()});   Iterator agentItr = agentsList.iterator();   while (agentItr.hasNext())           {               String agentCode = (String) agentItr.next();   Right now this is failing with the exception...  view plain print ? Note: Text content in the code blocks is automatically word-wrapped java.lang.ClassCastException: org.springframework.util.LinkedCaseInsensitiveMap cannot be cast to java.lang.String       at com.wu.interstream.advising.loaders.AgentsRetriever.execute(AgentsRetriever.java:54)   So it looks like AgentList is made up of LinkedCaseInsensitiveMap objects instead of String objects. Why is this?  Thanks in advance for any help.
解决： If the query returns more than one column the List is made up of Map elements.  You might want to try  String agentCode = (String)((Map)agentItr.next()).get("AGENTSURROGATECODE");