IMHO
Oracle
allows passing a list of objects (collections) to procedures. This is helpful in
many cases where you need to pass a list of objects to a procedure that have to
be processed and then inserted to database table. This will save
some network round trips or IO between application and database
server. Low level interfaces like OCI/OCCI support this.
Unfortunately only way one can pass a list in JDBC is using ARRAY type.
This is not supported by some databases like Sybase. So I think the inherent
problem is in JDBC rather than ibatis.
_
-----Original Message-----Take a look at user defined types. When you use the stored procedure, you need to define the parameter map. There you have the option of specifying the types. I am still not sure, that you have a sp which takes a List as a input parameter? and each element inside the list is again a user defined object? Why???
From: Debasish Dutta Roy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 11, 2006 10:42 AM
To: [email protected]
Subject: Re: HOW TO pass List of objects(a DTO) as single IN parameter to Stored Procedure
The sp is then so specific to your application and your objects. Why would you want to do something like that. Seems it is not designed properly.
On 7/11/06, chaithanya ibatis <[EMAIL PROTECTED]> wrote:not possible?????????////
with or without ibatis
On 7/11/06, Beemsterboer Software < [EMAIL PROTECTED] > wrote: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
