Re: How to avoid database deadlocks?

Victor Langelo <[email protected]>
Newsgroups gmane.comp.java.sun.ejb.general
Message-ID <[email protected]>
Janne Mattila wrote:

>Hi,
>
>isModified could work, have to check that one...separate transactions is a
>big no-no. Would mess up transactional integrity.
>
>
What kind of integrity requirement requires you to update all artists
and their records in one transaction? Or for that matter, why not put
each artist and their records in a single transaction?

Even if you solve this deadlock problem, long pessimistic transactions
will cause you many more problems.

--Victor

===========================================================================
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".
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.