ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: sproc call / long / empty value
Date Mon, 14 Aug 2006 18:51:16 GMT
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