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 > --------------------------------------------------------- > > >
