hi, I appreciate your advice, Larry.
Your guess is right to the point! > Odds are good that your driver is choking on it. > > Try this: > > <statement> > INSERT INTO testtable (seqNo, name) > VALUES (#seqNo:INTEGER#, #name:VARCHAR#) > </statement> > > This will tell iBATIS what the types are, and it can then tell your driver. > > I think that will fix it. > > Larry > > > On 12/7/05, Toshiaki Takashima <[EMAIL PROTECTED]> wrote: > > hi, > > > > > Larry > > > > thank for your response. > > > > > > > Are you getting a SQLException? > > > > I get Exception when executing insert statement > > with setting "name" parameter to null such as : > > > > com.ibatis.common.jdbc.exception.NestedSQLException > > > > --- The error occurred in Map.xml. > > --- The error occurred while applying a parameter map. > > --- Check the insertBu-InlineParameterMap. > > --- Check the parameter mapping for the 'name' property. > > --- Cause: java.sql.SQLException: parameter number is wrong > > Caused by: java.sql.SQLException: parameter number is wrong > > > > > > > > > > thanks, > > > > > > > > > > Larry > > > > > > > > > On 12/7/05, Toshiaki Takashima <[EMAIL PROTECTED]> wrote: > > > > Hi there > > > > > > > > I defined sql Map definition for select statement > > > > as follows : > > > > > > > > > > > > <select id="getBgList" resultClass="Result"> > > > > SELECT > > > > SEQNO as seqNo, > > > > NAME as name > > > > FROM testtable > > > > WHERE > > > > NME like #paraName# > > > > </select> > > > > > > > > This Statement works, but following insert statement > > > > fails when null(java) value is specified to any parameters > > > > even if you use valid Bean Class which has correct > > > > properties : > > > > > > > > <statement> > > > > INSERT INTO testtable > > > > VALUES ( > > > > #seqNo#, > > > > #name# > > > > ) > > > > </statement> > > > > > > > > But statement below works fine even if null parameters are > > > > contained : > > > > > > > > <statement parameterClass="Parameter"> > > > > INSERT INTO testtable > > > > VALUES ( > > > > #seqNo#, > > > > #name# > > > > ) > > > > </statement> > > > > > > > > > > > > > > > > > > > > So, I wonder I must specify parameterMap or parameterClass for > > > > every SQL Map definition. > > > > > > > > > > > > I thought it is just a performance issue for whether you should > > > > specify parameterMap / parameter Class or not. > > > > > > > > Should I always specify parameterMap / parameterClass attribute? > > > > > > > > Please teach me ! > > > > > > > > > > > > thanks, > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------- > > 第二ソリューションビジネス統括部・第一ソリューション部 > > > > 高島俊昭 > > mailto:[EMAIL PROTECTED] > > 内線 :7576-4406 > > > > 株式会社富山富士通 > > 〒939-2392 富山県婦負郡八尾町保内2-2-1 > > TEL 076-455-3131 > > FAX 076-455-0935 > > --------------------------------------------------------- > > > > > > --------------------------------------------------------- 第二ソリューションビジネス統括部・第一ソリューション部 高島俊昭 mailto:[EMAIL PROTECTED] 内線 :7576-4406 株式会社富山富士通 〒939-2392 富山県婦負郡八尾町保内2-2-1 TEL 076-455-3131 FAX 076-455-0935 ---------------------------------------------------------
