Thanks Jeff and Arved - no idea how I missed the "I" in ACID transactions!
Looks like I've got the information I need to try and track down this
deadlock now.
Has anyone else experienced container-level deadlocks who could give me any
pointers?
Thanks again,
Dan/tastapod
ps. What a helpful mailing list :o)
At 10:41 03/04/2001 -0600, you wrote:
>See the URL below. The constants defined in the java.sql.Connection class
>define what they mean.
>
>http://java.sun.com/j2se/1.3/docs/api/java/sql/Connection.html
>
>Also, Oreilly's Enterprise JavaBeans 2nd edition has a very good overview of
>what these isolation levels mean.
>
>Jeff.
>
>Dan North wrote:
>
> > Hi list.
> >
> > There is an isolation="serializable|committed|uncommitted|repeatable_read"
> > attribute for <entity-deployment> that isn't very clearly documented.
> >
> > Does anyone know what these levels do (or where I should look to find
> > out)? In particular, on one finder method (findByParent for a tree-based
> > data structure) I get a deadlock (in the app server, not the database) if
> > the finder method is fired twice in rapid succession, and I'm wondering
> > whether changing the isolation to "repeatable_read" might cure this?
> >
> > Or am I barking up a completely inappropriate tree?
> >
> > Thanks,
> > Dan/tastapod
> >
> > --
> > Dan North
> > VP Development - Cadrion Software Ltd - +44 (0)20 7440 9550
> >
> > CONFIDENTIALITY
> > This e-mail and any attachments are confidential
> > and may also be privileged. If you are not the named recipient,
> > please notify the sender immediately and do not disclose the
> > contents to another person, use it for any purpose, or store
> > or copy the information in any medium
>
>--
>Jeff Hubbach
>Internet Developer
>New Media Designs, Inc.
>www.nmd.com
--
Dan North
VP Development - Cadrion Software Ltd - +44 (0)20 7440 9550
CONFIDENTIALITY
This e-mail and any attachments are confidential
and may also be privileged. If you are not the named recipient,
please notify the sender immediately and do not disclose the
contents to another person, use it for any purpose, or store
or copy the information in any medium
