ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chetan Nayak" <chetannay...@gmail.com>
Subject Re: Execute batch process for Update statement
Date Wed, 23 Jan 2008 14:14:13 GMT
I think u need to use <iterate> for this query ,take a look at IBATIS
developer guide ,they have examples on this .

Thanks
Chetan



On 1/23/08, Jasmin_Mehta@nexweb.org <Jasmin_Mehta@nexweb.org> wrote:
>
>
> Jay,
>
> I saw your posting in iBATIS forum with subject line "iBatis batch
> executing same performance as Jdbc - Thanks!"
>
> I am using iBATIS 2.3.0 and do not have any DAO (no Spring). My
> requirement is to run execute batch update for prepared statement :
>
> *update otm_staging set status = 'Processed' where sequence = ?*
>
> Where 'sequence' will get values from array of integer like {1, 2, 3, 5,
> 7, 9, 11, 12, 14 ........ }
>
> How should I configure my sqlMap resource xml file for the query? Can  I
> still use your method
>
> 'private Object batch(SqlMapClient sqlMap, int batchType, String
> methodName, Object argument)'
>
> from the posting ?
>
> thanks
> jasmin
>
> *
> ******************************************************************************
> *ATTENTION ATTENTION ATTENTION ATTENTION ATTENTION
> Our domain name is changing.  Please take note of the sender's
> e-Mail address and make changes to your personal address list,
> if needed.  Both domains will continue to work, only for a limited
> time.
>
> ******************************************************************************
> This email and any files transmitted with it are intended solely for
> the use of the individual or agency to whom they are addressed.
> If you have received this email in error please notify the Navy
> Exchange Service Command e-mail administrator. This footnote
> also confirms that this email message has been scanned for the
> presence of computer viruses.
>
> Thank You!
> *
> ******************************************************************************
> *
>

Mime
View raw message