Hi,
I am having some trouble with database locking when Castor retrieves
objects in the DbLocked mode.
The scenario is:
I have an object called DEVICE which inherits from the base class
COMPONENT. This relation is also expressed in the Castor mapping file
using the "extends" construct.
Now, in the first operation (1st transaction) I retrieve a DEVICE
object. Without closing this transaction, I call another method that
opens a second transaction and tries to retrieve another row from
DEVICE. But, this retrieve gets blocked and eventually times out (I am
guessing the entire COMPONENT/DEVICE table is being locked by the first
retrieve).
What can I do to prevent this from happening?
Note: I cannot close the first transaction (since I have to
update/rollback based on the response from the method called), and also
cannot pass the transaction to the other method (since it is executed in
a different JVM).
I have the DEVICE and COMPONENT tables indexed by their ID fields.
Database being used is MySql 4.0.17
Regards, Vishal.
Confidentiality Notice
The information contained in this electronic message and any attachments to this
message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged
information. If
you are not the intended recipient, please notify the sender at Wipro or [EMAIL
PROTECTED] immediately
and destroy all copies of this message and any attachments.
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
