[castor-user] Dblocked mode & Mysql DB

[thomas.jimmy]

Hi,               I working with Castor 0.9.5.3 (Cache type = NONE) & mySQL 4 and I am facing problems wherein castor says Read lock timeout, this usually occurs when I try to read an object in one thread, but at the same time some other thread has dblocked that object. I also happen to notice that, when I do a Dblock on an object, Castor applies both a read & write lock on the record, but mysql allows read on those records mapped to the object, at its prompt.   I guess the read lock timeouts are happening because the object that’s been dbLocked, is been held in the lock state for more than the timeout period and the reading thread is not allowed access to this object. But this could be serious limitation, since in my application there many threads working on the same object/table and if a thread happen to dblocked that object for some period of time, then the remaining threads who just want to read has to wait, till the read lock is released.   So I would like to know is there any way that I could just do a write lock and not read lock on the object that I would like to update. Also does Castor have any specific way of retrieving objects referenced in an object; say in the order it’s been mapped in the mapping file or does Castor loads the object in an arbitrary fashion.     Thanks & Regards, Jimmy Thomas     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-user