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.b...@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-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org


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

Reply via email to