You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ojb-user@db.apache.org by Jay Xu <jx...@san.rr.com> on 2004/03/23 15:38:55 UTC

Packed Field (DB2/400) Mapping

Hello,

I am having a problem with OJB mapping of DB2/400 Packed Field. I mapped Packed Field in DB2/400 to DECIMAL with Java type BigDecimal. When I read records from database, it is fine. But when I try to update the record using OJB, it generates a SQL with that Packed Filed as null value. For example. I have a BigDecimal aField = 12345, but in SQL,

1080015521538|1222|0|statement|UPDATE CRPIBMS SET MSACFL=?,MSCHBY=?,MSCHDT=?,MSCHTM=?,MSDADM=?,MSDATE=?,MSDATT=?,MSDBY=?,MSDCNS=?,MSDDT=?,MSDFAM=?,MSDORD=?,MSDREF=?,MSDRL1=?,MSDRL2=?,MSDRL3=?,MSDTM=?,MSFLG1=?,MSFLG2=?,MSFLG3=?,MSFROM=?,MSACC2=?,MSACCT=?,MSEPIS=?,MSFCID=?,MSUREF=?,MSRSTS=?,MSSTFL=?,MSSTS=?,MSTEXT=?,MSTIME=?,MSTO=?,MSTYPE=?,MSVBY=?,MSVDT=?,MSVTM=? WHERE MSID = ? |UPDATE CRPIBMS SET MSACFL='',MSCHBY='',MSCHDT='2004-02-11',MSCHTM='16:32:00',MSDADM='Y',MSDATE='2004-02-11',MSDATT='Y',MSDBY='',MSDCNS='',MSDDT='2004-02-11',MSDFAM='',MSDORD='',MSDREF='Y',MSDRL1='',MSDRL2='',MSDRL3='',MSDTM='16:32:00',MSFLG1='',MSFLG2='',MSFLG3='',MSFROM='LAB',MSACC2='',MSACCT='000000055616',MSEPIS='1',MSFCID='100',MSUREF='2305',MSRSTS='F',MSSTFL='1',MSSTS='R',MSTEXT='ABNORMAL',MSTIME='16:32:00',MSTO='SMSWEB',MSTYPE='O',MSVBY='SMSWEB',MSVDT='2004-03-22',MSVTM='20:18:38' WHERE MSID = '1' 


with Packed Field MSACC2=''. Actually, it should be MSACC2='12345'. This cause SQL exception that this colume does not allow null value.

Thank you for your help!