Re: SQLMap - Fetching ArrayList within an HashMap result

[Vamsee Kanakala]

srividhya umashanker wrote:
<select id="getColumnDetails" resultClass="java.util.ArrayList"
parameterClass="int">
   SELECT column_id
     FROM column_details
     WHERE tree_id = #value#
 </select>
 

So, there are multiple column_ids which have the same tree_id. In that 
case, you shouldn't be using "where tree_id = #value#". It should be 
"where tree_id in (#value1#, #value2#)" etc. Change your code according 
to that. I never used resultMaps, but there should be some way to put 
the resulting values from getColumnDetails into a List, which in turn is 
put in the HashMap assigned to a key.

HTH,
Vamsee.