Return-Path: 
 <user-java-return-19152-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 91314 invoked from network); 14 Apr 2010 19:25:27 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 14 Apr 2010 19:25:27 -0000
Received: (qmail 17629 invoked by uid 500); 14 Apr 2010 19:25:26 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 17617 invoked by uid 500); 14 Apr 2010 19:25:26 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 17610 invoked by uid 99); 14 Apr 2010 19:25:26 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Apr 2010 19:25:26 +0000
X-ASF-Spam-Status: No, hits=2.2 required=10.0
	tests=AWL,FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [206.190.48.186] (HELO web52503.mail.re2.yahoo.com)
 (206.190.48.186)
    by apache.org (qpsmtpd/0.29) with SMTP; Wed, 14 Apr 2010 19:25:19 +0000
Received: (qmail 25956 invoked by uid 60001); 14 Apr 2010 19:24:57 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
 t=1271273097; bh=VkuNlxgW0E9tPjqI67MwYokkXyS217cBMLo+XByg/5o=;
 h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
 b=kZYatV1eVZyOM2gTBbHx3JuWT+cds/i9ATl0FOraqMhUojKNOzPYhK58LYTg3RlPrj1hDWphXfK7stA03dsw70SLiCBgm5Ddh8UmMRELWeBNfsONFVNqldgMGuYvXoHekU41sDFrgF49147a6NigBxoEVKUC2iTXklta0lidjdg=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
  b=vEwkiME+ggPPFdQ3hedH8HPzWIxE5dVlBT05ufjvcqz/k0LGrW0LMaR/aJ5McDclqNSUuzl2HeHIcmxF3N5vbqaWNh8Z1M0cpONIqNLocgO6knGSoPSIW0CLlKlaMUI5fq2O4+BQ3d3eAowCcPfXrpGd9ZQqfF2WOOWuDCgeTiM=;
Message-ID: <625303.25920.qm@web52503.mail.re2.yahoo.com>
X-YMail-OSG: 5Ilpoi4VM1nl4.yCA4NU1jf1p4TSS_jpqm57VtXfuloQKfk
 xm7l5BdQCBzzGN5Yyu6Xb5rkk7MOozj9dnO6CyU3LZkf2XmIukxx4B7sL5ej
 eplH9kHr6d6iU4Rg06LtCBqfJbSgmuBjgUrETBGSYOHaW.LF.NKf1xzx4vkH
 OmnVUn2pPN3cDyH2.JNPNAzxLVs1oVXzb6ohc.CqUdhf2bOr5UQESz8_KWBW
 zSe3ewvuxG9WFoCDLwJPB3.UzlU0wAJkYZEGjS93bPpIPl0f9g4YmWwObgVy
 DjFt4i0znikhmA2aRIZaSHjVI8LQkNd.RzhsTZxQNeVF974htFW6QeUY-
Received: from [72.248.180.18] by web52503.mail.re2.yahoo.com via HTTP;
 Wed, 14 Apr 2010 12:24:57 PDT
X-Mailer: YahooMailRC/348.5 YahooMailWebService/0.8.100.260964
Date: Wed, 14 Apr 2010 12:24:57 -0700 (PDT)
From: kiran vuppla <kirankumar_vuppla@yahoo.com>
Subject: Stored Procedure Call
To: iBatis Forum <user-java@ibatis.apache.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1834339402-1271273097=:25920"

--0-1834339402-1271273097=:25920
Content-Type: text/plain; charset=us-ascii

Hi,

 I would like to know if the below code looks fine with syntax etc to call a stored procedure that is created on Sql-Server DB. I would appreciate if anyone can let me know the corrections as this is not working properly for me.

<parameterMap id="validateParms" class="map" >
     <parameter property="Id" jdbcType="INTEGER" javaType="java.lang.Integer" mode="OUT"/> 
    <parameter property="TeamNo" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>  
</parameterMap>

<procedure id="getTeamInfo"  parameterMap="validateParms">
{? = call get_Team_Name(?)} 
</procedure>

Java Code:

Map<String,Object> map = new HashMap<String,Object>();
map.put("TeamNo", key);
map.put("Id",new Integer(-1));
getSqlMapClientTemplate().queryForObject("getTeamInfo", map);
(Integer) result = map.get("Id");

Thanks.


      
--0-1834339402-1271273097=:25920
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><div>Hi,</div><div><br></div><div>&nbsp;I would like to know if the below code looks fine with syntax etc to call a stored procedure that is created on Sql-Server DB. I would appreciate if anyone can let me know the corrections as this is not working properly for me.</div><div><br></div><div><div>&lt;parameterMap id="validateParms" class="map" &gt;</div><div>&nbsp;&nbsp; &nbsp; &lt;parameter property="Id" jdbcType="INTEGER" javaType="java.lang.Integer" mode="OUT"/&gt;&nbsp;</div><div>&nbsp;&nbsp; &nbsp;&lt;parameter property="TeamNo" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/&gt; &nbsp;</div><div>&lt;/parameterMap&gt;</div><div><br></div><div>&lt;procedure id="getTeamInfo" &nbsp;parameterMap="validateParms"&gt;</div><div><span class="Apple-tab-span" style="white-space:pre">
	</span>{? = call get_Team_Name(?)}&nbsp;</div><div>&lt;/procedure&gt;</div><div><br></div><div>Java Code:</div><div><br></div><div><div>Map&lt;String,Object&gt; map = new HashMap&lt;String,Object&gt;();</div><div>map.put("TeamNo", key);<span class="Apple-tab-span" style="white-space:pre">	</span></div><div><span class="Apple-tab-span" style="white-space:pre">m</span>ap.put("Id",new Integer(-1));</div><div>getSqlMapClientTemplate().queryForObject("getTeamInfo", map);</div><div>(Integer) result = map.get("Id");</div><div><br></div><div>Thanks.</div><div><br></div><div><br></div></div></div><div style="position:fixed"></div>


</div><br>

      </body></html>
--0-1834339402-1271273097=:25920--