ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jaggernat <jaydeeproy...@yahoo.com>
Subject Re: mapping column with array
Date Fri, 14 Sep 2007 02:13:09 GMT

hi,
I am using Db2 version 7.x

ID_NO is defined as CHAR(10)
and PRICE is defined as Decimal(3,4)

thanks,
J


nmaves wrote:
> 
> What is does the database look like?  What are the column types?
> 
> On 9/13/07, jaggernat <jaydeeproy123@yahoo.com> wrote:
>>
>>
>> hi guys
>>
>> I am using DAO in my backend with IBATIS
>>
>>
>> I have a java value-object in which i  have defined something like
>> public String                  id = null;
>> public BigDecimal[]        access = null;
>> and set() methods
>> and get() methods
>>
>> and in my IBATIS xml file, i am mapping my value object fields to table
>> columns
>>
>> like
>>
>>       SELECT         ID_NO        AS  id,
>>                            PRICE         AS  access
>>        FROM  TABLE WHERE...
>>
>> but in above sql   'access'   defined as BigDecimal[ ] doesnt seem to
>> work.
>>
>> any idea if it should be access  OR   access.intvalue  OR   anything
>> else?
>>
>>
>>
>> any help would be greatly appreciated
>>
>> thanks a lot
>> Jay
>>
>> --
>> View this message in context:
>> http://www.nabble.com/mapping-column-with-array-tf4439234.html#a12665891
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
> 
> 

-- 
View this message in context: http://www.nabble.com/mapping-column-with-array-tf4439234.html#a12667259
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message