ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yogish...@tcs.com
Subject Null parameter value to stored procedure
Date Fri, 07 Jul 2006 14:00:09 GMT
Hi,

i am trying to pass null parameter value to stored procedure

ex:

<procedure id="Search" parameterClass="java.util.HashMap"
            resultMap="results">

            { call testStoredProc(#id#)}

</procedure>

sometimes id parameter value comes from the HashMap contains null value.

how ibatis handles this and how can i configure....? i am getting error
when i pass null value.

I tried with passing default value like this { call
testStoredProc(#id:NUMERIC:-1#)} and it works.

Question is without assigning default value for the parameter is there any
other way i can resolve this.

thanks in advance
Yogish
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you



Mime
View raw message