stored proc doesn't return output parameter

["Deshpande, Bhushan M (IT)" <Bh...@morganstanley.com>]

Hi All ,
   I am using Ibatis 2.1.5 to execute a stored proc on sybase databse
which retuns a string result .
----------------------
Entries in contiguration xml file is 
<parameterMap id="getContactParameters" class="map" >

<parameter property="contactId" jdbcType="INTEGER"
javaType="java.lang.Integer" mode="IN"/>

<parameter property="firstName" jdbcType="VARCHAR"
javaType="java.lang.String" mode="OUT"/>

</parameterMap>

<procedure id="spGetContacts" parameterMap="getContactParameters" >

{? sp_sample_get_contact (?)} 

</procedure>

 

also tried 

{? = call sp_sample_get_contact (?)}  but of no avail ;(

-----------------------------

Code in the servlet  for excution 

Reader configReader = Resources.getResourceAsReader("SqlMapConfig.xml");

SqlMapClient sqlMap =
SqlMapClientBuilder.buildSqlMapClient(configReader); 

sqlMap.startTransaction();

HashMap paramMap = new HashMap();

paramMap.put("firstName","");

paramMap.put("contactId", new Integer(1));

sqlMap.queryForObject("spGetContacts", paramMap);

String firstName = (String) paramMap.get("firstName");

sqlMap.commitTransaction();

-----------------------------------------------

Variable FirstName returns "0" instead of expected result .

However if the same operation is tried with simple query way it works
fine .

<select id="getContact" parameterClass="int"
resultClass="contact">select FIRSTNAME as firstName,LASTNAME as
lastName, CONTACTID as contactId from CONTACT where CONTACTID =
#contactId#</select>

Thanks for your all help in advance .
--------------------------------------------------------

NOTICE: If received in error, please destroy and notify sender.  Sender does not waive confidentiality or privilege, and use is prohibited.

Re: stored proc doesn't return output parameter

[Jeff Butler <je...@gmail.com>]

Try reordering the parameters in your parameter map. The first parameter 
should be the String OUT parameter, the second parameter should be the 
Integer IN parameter.
 Jeff Butler

 On 8/31/05, Deshpande, Bhushan M (IT) <Bh...@morganstanley.com> 
wrote: 
> 
>  Hi All ,
>  I am using Ibatis 2.1.5 to execute a stored proc on sybase databse which 
> retuns a string result .
> ----------------------
> Entries in contiguration xml file is 
>  
> <parameterMap id="getContactParameters" class="map" >
> 
> <parameter property="contactId" jdbcType="INTEGER" javaType="
> java.lang.Integer" mode="IN"/>
> 
> <parameter property="firstName" jdbcType="VARCHAR" javaType="
> java.lang.String" mode="OUT"/>
> 
> </parameterMap>
> 
> <procedure id="spGetContacts" parameterMap="getContactParameters" >
> 
> {? sp_sample_get_contact (?)} 
> 
> </procedure>
> 
>  also tried 
> 
> {? = call sp_sample_get_contact (?)} but of no avail ;(
> 
> -----------------------------
> 
> Code in the servlet for excution 
> 
> Reader configReader = Resources.getResourceAsReader("SqlMapConfig.xml");
> 
> SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(configReader); 
> 
> sqlMap.startTransaction();
> 
> HashMap paramMap = new HashMap();
> 
> paramMap.put("firstName","");
> 
> paramMap.put("contactId", new Integer(1));
> 
> sqlMap.queryForObject("spGetContacts", paramMap);
> 
> *String firstName = (String) paramMap.get("firstName");*
> 
> sqlMap.commitTransaction();
> 
> -----------------------------------------------
> 
> Variable FirstName *returns "0" instead of expected result .*
> 
> However if the same operation is tried with simple query way it works fine 
> .
> 
> <
> select id="getContact" parameterClass="int" resultClass="contact">select 
> FIRSTNAME as firstName,LASTNAME as lastName, CONTACTID as contactId from 
> CONTACT where CONTACTID = #contactId#</select> 
> 
> Thanks for your all help in advance .
>  ------------------------------
>  
> NOTICE: If received in error, please destroy and notify sender. Sender 
> does not waive confidentiality or privilege, and use is prohibited.
>