Shooting from the hip (just to get you thinking) you can explore either: 1) Message Queue to start calculations and THEN calling create(). 2) Start calculations from outside a TX and THEN calling create().
Hope that gets you started... Juan Pablo Lorandi Chief Software Architect Code Foundry Ltd. [EMAIL PROTECTED] Barberstown, Straffan, Co. Kildare, Ireland. Tel: +353-1-6012050 Fax: +353-1-6012051 Mobile: +353-86-2157900 www.codefoundry.com > -----Original Message----- > From: A mailing list for Enterprise JavaBeans development > [mailto:[EMAIL PROTECTED]] On Behalf Of Richard S.Martin > Sent: Wednesday, July 17, 2002 5:14 PM > To: [EMAIL PROTECTED] > Subject: Entity creation locking problem > > > Problem: > > 1. The uniqueness of the entity beans is based upon an unique > constraint on the primary key field in the underyling database. > > 2. The ejbCreate method on the BMP entity bean, due to > various essential business processes, takes a long time to > write the data to the table. (in the region of 5-10 secs.) > > 3. As soon as the INSERT statement occurs, the transaction > acquires a table-lock to ensure the uniquness of the primary key. > > 4. The lock is only released when the transaction commits or > rollsback. > > 5. The consequence of this is that every ejbCreate causes the > table to be exclusively locked for about 5 seconds, meaning > we can handle only a single ejbCreate at any time! > > How can this problem be resolved? > > > > ============================================================== > ================ > This email and any files transmitted with it are confidential > and intended solely for the use of the individual or entity > to whom they are addressed. All information is the view of > the individual and not necessarily the company. If you are > not the intended recipient you are hereby notified that any > dissemination, distribution, or copying of this communication > and its attachments is strictly prohibited. If you have > received this email in error please notify: [EMAIL PROTECTED] > > > ============================================================== > ================ > > ============================================================== > ============= > 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".
