so why are you using an array in your pojo.... I would just use a Float with that column def
On 9/13/07, jaggernat <[EMAIL PROTECTED]> wrote: > > > 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 <[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. > >
