Re: sproc call / long / empty value

[Jeff Butler]

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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED] > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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 <[EMAIL PROTECTED] > 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