Hi Gene & Ashwani,
Thanks for your clarifications and advice.
I will resort to Session Bean along with Stored Procedure.
Wenhui
----- Original Message -----
From: "Gene Chuang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 4:03 PM
Subject: Re: About Entity Bean's batch updating capability
> Hi Wenhui,
>
> Yes, in EJB 1.1 CMP you are limited to single-row updates and inserts.
> However many vendors have taken liberal optimization initiatives for CMP
> 2.0, for example, bulking sql loads from ejbFind() within a txn. In the
> same grain, I can't see why vendors cannot optimize multiple inserts or
> updates within a single transaction to a single bulk-call; perhaps some
> vendors have already done this!
>
> However, if you do/can not rely on vendor-specific bulk updates/inserts,
> then JDBC/SessionBean is your only alternative. Simply put, entity beans
> are not designed for bulk updates/inserts!
>
> Gene
>
> -----Original Message-----
> From: Wenhui Bai at YSD
> To: [EMAIL PROTECTED]
> Sent: 8/13/2001 5:56 PM
> Subject: About Entity Bean's batch updating capability
>
> Hi Dear All,
>
> According to the specification of EJB 1.1, Entity Bean can only
> update/insert one record at one call.
> If I wanted to update a batch of records at one call(for performance), I
> would have to implement
> specific method or employ Session Bean.
>
> Am I missing something or are there any other approaches?
>
> Cheers,
> Wenhui
>
> ========================================================================
> ===
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
> ===========================================================================
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
