ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: sproc call / long / empty value
Date Mon, 14 Aug 2006 19:26:38 GMT
Well even the iSeries nuts know the difference between a string and a
number. :-)

What's the procedure expecting - number or string?

Jeff Butler


On 8/14/06, Larry Meadors <lmeadors@apache.org> wrote:
>
> Those crazy iSeries nuts...don't they curse at you for calling it an
> AS/400?
>
> Anyway, I guess I'd try 0, but if that's a valid value (i.e., not the same
> as "empty" or "null"), then I'd try it as a String.
>
>
> Larry
>
>
> On 8/14/06, Reuben Firmin <Reuben.Firmin@copart.com> wrote:
> >
> >  I didn't write the sproc. Don't ask me :D
> >
> > It is acceptable in AS400-land - I guess the question boils down
> > to: what is the least terrible hack on the DAO/Ibatis side of things?
> >
> > -----Original Message-----
> > *From:* larry.meadors@gmail.com [mailto:larry.meadors@gmail.com]*On
> > Behalf Of *Larry Meadors
> > *Sent:* Monday, August 14, 2006 11:51 AM
> > *To:* user-java@ibatis.apache.org
> > *Subject:* Re: sproc call / long / empty value
> >
> > I am confused..what is an "empty" number?
> >
> > Larry
> >
> >
> > On 8/14/06, Reuben Firmin <Reuben.Firmin@copart.com > wrote:
> > >
> > >  How do I pass an empty value into a java.lang.Long field for a sproc?
> > > Null is not acceptable on the sproc side of things, and Ibatis won't take
> > > "".
> > >
> > > My sproc definition is:
> > > <statement ... parameterMap="testParams" ...>
> > >     {call TEST3SQL(?, ?, ?, ?)}
> > > </statement>
> > >
> > > and the params are:
> > >
> > > <parameterMap id="testParams" class ="map">
> > >             <parameter property="userNumber" jdbcType="INTEGER"
> > > javaType="java.lang.Integer" mode="IN"/>
> > >             <parameter property="lotNumber" jdbcType="BIGINT" javaType="
> > > java.lang.Long" mode="IN"/>
> > > ...
> > >
> > >
> > > If I call the sproc directly in the IBM query tool, I can do:
> > >
> > > call TEST3SQL(4, "", ?, ?)
> > >
> > > Should I just tell Ibatis that it is a string field, and pass "", or
> > > is there a better way?
> > >
> > > Thanks
> > > Reuben
> > >
> >
> >
>

Mime
View raw message