[jira] Closed: (IBATIS-265) Map data into HashMaps: HashMap of List of HashMaps

["Sven Boden (JIRA)" <ib...@incubator.apache.org>]

     [ http://issues.apache.org/jira/browse/IBATIS-265?page=all ]
     
Sven Boden closed IBATIS-265:
-----------------------------

    Resolution: Invalid
     Assign To: Sven Boden

Use a HashMap as resultClass and use queryForList()... you will get a list of HashMaps. No changes are required as it's already supported.


> Map data into HashMaps: HashMap of List of HashMaps
> ---------------------------------------------------
>
>          Key: IBATIS-265
>          URL: http://issues.apache.org/jira/browse/IBATIS-265
>      Project: iBatis for Java
>         Type: Improvement
>     Reporter: Stefan Friedrich
>     Assignee: Sven Boden
>     Priority: Minor

>
> We tried to implement the HashMaps as results for our queries. The problem is, that whenever a HashMap is set as the resultClass, a queryForObject is called and so, every select can only return ONE result. In our application we expect a list of HashMaps at certain locations. The solution for our problem would be very simple and - in our opinion - would work with only three new lines of code:
> The Method BasicResultMap.getResults(RequestScope request, ResultSet rs) the targetType for further calls is set: 
> if (resultClass == null) { 
> 	throw new SqlMapException("The result class was null when trying to get results for ResultMap named " + getId() + ".");
> } else if (Map.class.isAssignableFrom(resultClass)) { 
> 	columnValues[i] = getNestedSelectMappingValue(request, rs, mapping, Object.class); 
> } else if (DomTypeMarker.class.isAssignableFrom(resultClass)) { 
> 	Class javaType = mapping.getJavaType(); 
> 	if (javaType == null) { 
> 		javaType = DomTypeMarker.class; 
> 	} 
> 	columnValues[i] = getNestedSelectMappingValue(request, rs, mapping, javaType); 
> } else { 
> 	Probe p = ProbeFactory.getProbe(resultClass); 
> 	Class type = p.getPropertyTypeForSetter(resultClass, mapping.getPropertyName()); 
> 	columnValues[i] = getNestedSelectMappingValue(request, rs, mapping, type); 
> }
> The part that needs to be changed is in the first "else-Statement".
> if (resultClass == null) { 
> 	throw new SqlMapException("The result class was null when trying to get results for ResultMap named " + getId() + ".");
> } else if (Map.class.isAssignableFrom(resultClass)) { 
> 	Class javaType = mapping.getJavaType(); 
> 	if (javaType == null) { 
> 		javaType = Object.class; 
> 	} 
> 	columnValues[i] = getNestedSelectMappingValue(request, rs, mapping, javaType); 
> } else if (DomTypeMarker.class.isAssignableFrom(resultClass)) { 
> 	Class javaType = mapping.getJavaType(); 
> 	if (javaType == null) { 
> 		javaType = DomTypeMarker.class; 
> 	} 
> 	columnValues[i] = getNestedSelectMappingValue(request, rs, mapping, javaType); 
> } else { 
> 	Probe p = ProbeFactory.getProbe(resultClass); 
> 	Class type = p.getPropertyTypeForSetter(resultClass, mapping.getPropertyName()); 
> 	columnValues[i] = getNestedSelectMappingValue(request, rs, mapping, type); 
> }
> As you can see, the changes would have no effect, if no javaType was set. But for our concerns, we would set the javaType to java.util.ArrayList and everything would be just fine!
> Stefan

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira