Is id an Integer or an int? Also, the syntax in your example has:
#id:NUMERIC:# It should be: #id:NUMERIC# Not sure if that is causing a problem. On 5/26/05, Jason Hall <[EMAIL PROTECTED]> wrote: > > > Hi, > > I've tried every scenario from previous mailing-list, wike etc. > I'm using Oracle 9i (tried Oracle 9i & 10g jdbc thin driver) > > Everything works, i'm able to insert null data for varchar and ALSO able to > insert NUMBER data type too, but > it's always the value 0 (ZERO) inserted. For me to get rid of this inserted > ZERO I did a nullValue "-999" with data type VARCHAR NOT > > NUMERIC OR NUMBER. Now this worked! I was able to get a null value inserted > for both VARCHAR and NUMBER oracle data type. > > But my problem is why do i have to use a replacement -999 etc. to insert an > empty value? > > Is there something that I'm doing wrong? > > > my sqlmap is > > ..... > <?xml version="1.0" encoding="UTF-8" standalone="no"?> > <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" > "http://www.ibatis.com/dtd/sql-map-2.dtd";> > > <sqlMap namespace="Dummy"> > > <parameterMap id="paramMap" class="ca.cihi.omhrs.Dummy" > > <parameter property="id" jdbcType="VARCHAR" nullValue="-9999"/> > <parameter property="name" jdbcType="VARCHAR" /> > </parameterMap> > > <insert id="insertDummy" parameterMap="paramMap"> > > insert into Dummy(id,name) > values(?,?) > </insert> > > <!-- > <insert id="insertDummy" parameterClass="ca.cihi.omhrs.Dummy"> > > insert into Dummy(id,name) > values(#id:NUMERIC:#,#name:VARCHAR:NO_ENTRY#) > </insert> > --> > > </sqlMap>
