Try a search on ANSI/ISO SQL isolation levels.
Regards,
Arved Sandstrom
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Dan North
Sent: Tuesday, April 03, 2001 12:27 PM
To: Orion-Interest
Subject: isolation levels
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