ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: Handling Null value In Oracle - Everything fine but 1 problem
Date Thu, 26 May 2005 20:15:44 GMT
If it is long, and not Long (little "l" instead of big "L") you will
not be able to use nulls - long values cannot be null; only Long
values can.

Larry


On 5/26/05, Jason Hall <JHall@cihi.ca> wrote:
> im using java data type long.
> 
> the section with NUMERIC: is commented out - if you noticed.
> 
> 
> -----Original Message-----
> From: Paul Barry [mailto:pauljbarry3@gmail.com]
> Sent: Thursday, May 26, 2005 4:07 PM
> To: ibatis-user-java@incubator.apache.org
> Subject: Re: Handling Null value In Oracle - Everything fine but 1
> problem
> 
> 
> 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 <JHall@cihi.ca> 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>
>

Mime
View raw message