ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Richard Yee <r...@cruzio.com>
Subject Re: Returning Three ArrayLists
Date Thu, 20 Aug 2009 13:27:14 GMT
Ibatis won't do that for you. In your dao method you need to iterate  
through the list of three doubles and create the three lists of  
doubles. You'd then have to return them in a map or list or something

R

Sent from my iPhone

On Aug 20, 2009, at 12:51 AM, Richard Bibb <richard.bibb@aimhedge.com>  
wrote:

>
> I think I'm probably trying to use iBatis in a way that goes against  
> it's
> design, but for what I need to do it's correct.
>
> If I have a query like:
>
> select Number1, Number2, Number3
> from SOME_TABLE
> where COL_DATE > EARLY_TIME
> and COLD_DATE < LATER_TIME
>
> Assume that the query returns many rows,
>
> I would like to be able to return this data as three  
> ArrayList<Double>. I
> know I can return one ArrayList<SomeClass> where SomeClass contains  
> three
> numbers but that just adds a second layer of processing that I don't  
> want to
> do. I also know I could do three separate queries but as some of the  
> numbers
> may not have entries on some days it would again add a layer of  
> processing
> to add null data back into the ArrayLists returned
>
> I tried doing a result map containing three collections but the data
> returned was wrong (all of the collections seemed to get populated  
> with data
> from the first row).
> -- 
> View this message in context: http://www.nabble.com/Returning-Three-ArrayLists-tp25057560p25057560.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message