Return-Path: Delivered-To: apmail-ibatis-user-cs-archive@www.apache.org Received: (qmail 21105 invoked from network); 18 Sep 2006 09:00:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 18 Sep 2006 09:00:22 -0000 Received: (qmail 34116 invoked by uid 500); 18 Sep 2006 09:00:21 -0000 Delivered-To: apmail-ibatis-user-cs-archive@ibatis.apache.org Received: (qmail 34093 invoked by uid 500); 18 Sep 2006 09:00:21 -0000 Mailing-List: contact user-cs-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-cs@ibatis.apache.org Delivered-To: mailing list user-cs@ibatis.apache.org Received: (qmail 34082 invoked by uid 99); 18 Sep 2006 09:00:21 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Sep 2006 02:00:21 -0700 X-ASF-Spam-Status: No, hits=2.1 required=10.0 tests=HTML_MESSAGE,SPF_HELO_SOFTFAIL X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [202.162.198.50] (HELO mail.dayamega.com) (202.162.198.50) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 18 Sep 2006 02:00:07 -0700 Received: (qmail 47676 invoked from network); 18 Sep 2006 15:58:51 +0700 Received: from minhui.dayamega.com (HELO MinHui) (192.168.3.30) by 0 with SMTP; 18 Sep 2006 15:58:51 +0700 From: "Min Hui" To: Subject: Sample DataMapper for MS-SQL Server's stored procedure Date: Mon, 18 Sep 2006 15:58:21 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0018_01C6DB3B.43BA3CF0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Thread-Index: AcbbAJcZjhTsS6w3R+KBW1w8yPW5NA== X-Virus-Checked: Checked by ClamAV on apache.org Message-Id: <20060918090016.E763D10FB006@asf.osuosl.org> X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------=_NextPart_000_0018_01C6DB3B.43BA3CF0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Hi everybody, I am newbie with iBatis.NET. Currently I am still learning the framework. I have problem when testing call a store procedure with QueryForList() function. I have created the stored procedure named SP_Get_Person that has one argument @PER_ID int. The sp is just select 1 record based on PER_ID passed. Here are mapper XML: SP_Get_Person . When running the application, I got error: "An unhandled exception of type System.IndexOutOfRangeException occurred in ibatisnet.datamapper.dll I am very appreciate for any help Regards, Min Hui ------=_NextPart_000_0018_01C6DB3B.43BA3CF0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

Hi everybody,

 

I am newbie with iBatis.NET. Currently I am still = learning the framework. I have problem when testing call a store procedure with = QueryForList() function.

 

I have created the stored procedure named = SP_Get_Person that has one argument @PER_ID int. The sp is just select 1 record based on = PER_ID passed. Here are mapper XML:

 

 

<procedure id=3D"SP_GetPerson" parameterMap=3D"spParam" = resultMap=3D"SelectAllResult">

         =             &= nbsp;  SP_Get_Person

</procedure>

 

<parameterMap id=3D"spParam" class=3D"Person">

         =             &= nbsp;  <parameter property=3D"Id" column=3D"PER_ID" /> =

</parameterMap>

 

 

When running the application, I got error: “An unhandled exception of type System.IndexOutOfRangeException occurred in ibatisnet.datamapper.dll

 

I am very appreciate for any = help

 

 

Regards,

Min Hui

 

 

 

 

 

------=_NextPart_000_0018_01C6DB3B.43BA3CF0--