hi, I am using Db2 version 7.x id is defined as CHAR(10) and access 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 <[EMAIL PROTECTED]> 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.
