Re: pass List of objects as IN parameter to Stored Procedure

[chaithanya ibatis]

Hi,
i mean to say that i want to pass the java.util.List (which contains a DTO) as one of the parameters to the Stored Procedure
In that case could u provide me the code snippet?

On 7/11/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

you have an example:


<parameterMap id="misParametros" class="java.util.HashMap" >
    <parameter property="parametro1" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>    
  </parameterMap>
 <procedure id="ejecutaPKEjec" parameterMap="misParametros" >
    {call PKEjecSh(?)}
  </procedure>

 

Esperanza Echeverría de Miguel Steria España http://www.steria.es C/Menéndez y Pelayo,3 bis 46010 Valencia Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51 [EMAIL PROTECTED]

 

 

"chaithanya ibatis" <[EMAIL PROTECTED] > 11/07/2006 09:14 Please respond to user-java

To:        user-java@ibatis.apache.org         cc:                 Subject:        pass List of objects as IN parameter to Stored Procedure

HI,
I've been working with Oracle DB and iBatis
Can anyone tell me how to pass List of objects as IN parameter to Stored Procedure using iBatis
(mapping required in SQL map files of ibatis)
or any resources on this or code snippet


Thanks,
Chaithanya