I would not think that using CHAR(10) for the type would work.
When you had it just CHAR, what were you trying to update when you got the "inserted value too large for a column" error? Is it possible that it was more than 10 chars? Larry PS: Do not reply to existing messages to start a new thread. Send a new message to [email protected] instead. On 6/2/06, Krishnamoorthi, Sruthi (Raytheon) <[EMAIL PROTECTED]> wrote:
String type Thanks, Sruthi Krishnamoorthi 703-562-9732(Work) 537 A - (Raytheon) Location -----Original Message----- From: Clinton Begin [mailto:[EMAIL PROTECTED] Sent: Friday, June 02, 2006 1:00 PM To: [email protected] Subject: Re: IBATIS CHAR FIELD NULL VALUES- Urgent help required What Java type are you trying to map to the CHAR field? On 6/2/06, Krishnamoorthi, Sruthi (Raytheon) < [EMAIL PROTECTED]> wrote: > I have a char field which carries null value. > The samething with varchar field also. > when I pass null values it was throwing sql exception as incompatible column types. Then for varchar field i add #centerNo:VARCHAR# and same for DAte field #priorityDt:DATE#. > When I did same for CHAR #parentPatentNo:CHAR# I got error that inserted value too large for a column > Then I tried > #parentPatentNo:CHAR(10)# > Now it says incompatable type column. > > > <insert id="PatentedCaseTblInsert" parameterClass="PatentedCase"> > INSERT INTO PATENTED_CASE (PC_PATENT_NO,PATENT_APPLICATION_NO,FILING_DT, PATENT_ISSUE_DT, INVENTION_TITLE_TX, TECHNOLOGY_CENTER_NO, APPLICATION_PRIORITY_DT, REISSUE_PARENT_PATENT_NO, INVENTOR_QT, LAST_MODIFIED_USER_ID,LAST_MODIFIED_TS, ART_UNIT_NO) > VALUES(#patentNo#, #patentApplNo#, #filingDt#, #issueDt#, #title#, #centerNo:VARCHAR#, #priorityDt:DATE#, #parentPatentNo:CHAR(10)#, #inventorQt#, #lastModifiedUserId#, sysdate, #artUnitNo#) > </insert> > > > Could you please provide me a solution very urgently. > > Thanks, > Sruthi Krishnamoorthi > 703-562-9732(Work) > 537 A - (Raytheon) Location
