ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: Timeseries retrieval with iBatis
Date Tue, 18 Aug 2009 19:53:14 GMT
If I understand correctly, you'd either have to use join mapping (and
that's only supported in XML), or use two SELECTs (even subselects
mapped in a result map.  There's no way to express that you're
returning two lists with simple mappings.

Clinton

On Tue, Aug 18, 2009 at 10:31 AM, Richard Bibb<richard.bibb@aimhedge.com> wrote:
>
> I'm new to iBatis and I'm looking into using it in my project so far it
> appears to do what I want but I'm beginning to run into problems with what I
> want to do (I probably just have to look at things in anoter way)
>
> Currently I'm using the interface/annotations only method to get at the data
> (only because it's quicker for me) but I'm not adverse to using xml
>
> The data I am looking at is timeseries financial data (i.e. viewed from an
> object point of view Arrays or Array lists are what you want). In the
> database each item of data is stored as a separate row
>
> Selecting a single piece of data is easy, selecting an ArrayList of data is
> also easy.
>
> public interface BackAdjFutureMapper {
>        @Select("select value from back_adj_future " +
>                "where feed = #{feed} " +
>                "and instrument = #{instrument} " +
>                "and periodicity = #{periodicity} " +
>                "and date < str_to_date('19980721','%Y%m%d') " +
>                "and date > str_to_date('19980701','%Y%m%d')")
>                ArrayList<Double> selectBackAdjFuture(BackAdjFuture args);
>
> my question is how do I reurn both the timestamp and the value?
>
> public interface BackAdjFutureMapper {
>        @Select("select date, value from back_adj_future " +    <<< Note
the extra
> field
>                "where feed = #{feed} " +
>                "and instrument = #{instrument} " +
>                "and periodicity = #{periodicity} " +
>                "and date < str_to_date('19980721','%Y%m%d') " +
>                "and date > str_to_date('19980701','%Y%m%d')")
>                AnObjectContainingTwoArrayLists selectBackAdjFuture(BackAdjFuture
args);
>
> I tried creating an object with two array lists but I get the error: No type
> handler could be found to map the property 'date' to the column 'DATE'.  One
> or both of the types, or the combination of types is not supported.
>
> I also tried returning to a HashMap but again an error: Expected one result
> to be returned by selectOne(), but found: 12
>
> I can see that lots of annotations exist but there aren't any examples to go
> with them
>
> Can anyone help?
>
>
>
> --
> View this message in context: http://www.nabble.com/Timeseries-retrieval-with-iBatis-tp25028620p25028620.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