Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 7537 invoked from network); 11 Jul 2006 08:15:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 11 Jul 2006 08:15:06 -0000 Received: (qmail 91170 invoked by uid 500); 11 Jul 2006 08:15:03 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 91155 invoked by uid 500); 11 Jul 2006 08:15:03 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 91144 invoked by uid 99); 11 Jul 2006 08:15:03 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Jul 2006 01:15:03 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [195.121.247.12] (HELO psmtp03.wxs.nl) (195.121.247.12) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Jul 2006 01:15:02 -0700 Received: from [10.0.0.150] (ip54539330.speed.planet.nl [84.83.147.48]) by psmtp03.wxs.nl (iPlanet Messaging Server 5.2 HotFix 2.07 (built Jun 24 2005)) with ESMTP id <0J28000UGC8GIX@psmtp03.wxs.nl> for user-java@ibatis.apache.org; Tue, 11 Jul 2006 10:14:40 +0200 (MEST) Date: Tue, 11 Jul 2006 10:14:43 +0200 From: Beemsterboer Software Subject: Re: HOW TO pass List of objects(a DTO) as single IN parameter to Stored Procedure In-reply-to: <7640049f0607110100h13c24eefje9212848e35d345d@mail.gmail.com> To: user-java@ibatis.apache.org Message-id: <44B35DF3.3030508@beemsterboer-software.nl> MIME-version: 1.0 Content-type: multipart/alternative; boundary="Boundary_(ID_5oCEAAH9knsSMdUZUYsWuA)" User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) References: <7640049f0607110100h13c24eefje9212848e35d345d@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. --Boundary_(ID_5oCEAAH9knsSMdUZUYsWuA) Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT Hi, Passing a list of objects using a single input parameter? This is not even possible without iBatis. Greetings, Hans. chaithanya ibatis wrote: > HI, > I've been working with Oracle DB and iBatis > Can anyone tell me how to passList of objects(a DTO) as single IN > parameter to Stored Procedure using iBatis > for example > java.util.List list = new ArrayList(); > SampleDTO obj1 = new SampleDTO(); > SampleDTO obj2 = new SampleDTO(); > list add(obj1); > list add(obj2); > > i want to pass this list object as an IN parameter to procedure. > (mapping required in SQL map files of ibatis) > or any resources on this or code snippet > > thanks, > Chaithanya --Boundary_(ID_5oCEAAH9knsSMdUZUYsWuA) Content-type: text/html; charset=ISO-8859-1 Content-transfer-encoding: 7BIT Hi,

Passing a list of objects using a single input parameter?
This is not even possible without iBatis.

Greetings,
Hans.

chaithanya ibatis wrote:

HI,
I've been working with Oracle DB and iBatis
Can anyone tell me how to passList of objects(a DTO) as single IN parameter to Stored Procedure using iBatis
for example
java.util.List list = new ArrayList();
SampleDTO obj1 = new SampleDTO();
SampleDTO obj2 = new SampleDTO();
list add(obj1);
list add(obj2);

i want to pass this list object as an IN parameter to procedure.
(mapping required in SQL map files of ibatis)
or any resources on this or code snippet

thanks,
Chaithanya

--Boundary_(ID_5oCEAAH9knsSMdUZUYsWuA)--