Are you getting a SQLException? 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, > > > >
