Hi Arijit, Sorry I don't have a quick answer to your question... As always, a test case would help :-)
Arijit Ghosh wrote:
Hi, Ok as Micka�l is suggesting, this is not a BUG. So can anyone suggest how to implement the following cases, considering Concurrent Access --- 1. Student ----------> Professor Each Student will have multiple Professors. Also each Professor will have multiple Students. So this is an M:N relation. So how do we implement this ? 2. A ----> B B ----> C C ----> A Let each of the above relations be 1:N. This is a Cyclic Relation. How do we handle this situation ? Regards, Arijit Bruce Snyder wrote:This one time, at band camp, Arijit Ghosh said: AG>Hi, AG> AG> For 1:N bidirectional relation, we can restrict the relation to uni-directional and AG>use the Query to find out the results for the other. Now consider the following 2 AG>cases -- AG> AG>1. Student ----------> Professor AG> AG>Each Student will have multiple Professors. Also each Professor will have multiple AG>Students. So this is an M:N relation. So how do we implement this ? AG> AG>2. A ----> B AG> B ----> C AG> C ----> A AG> AG>Let each of the above relations be 1:N. This is a Cyclic Relation. How do we handle AG>this situation ? AG> AG>In the above cases, concurrent access will lead to Deadlock. Isn't it ? Arijit, What about using a stricter locking of the objects (e.g. exclusive, dbLocked)? This would disable concurrent loading of the objects. Bruce AG>Micka�l Guessant wrote: AG> AG>> Arijit Ghosh wrote: AG>> > What exactly did you mean by design issue ? Does it mean that 2 AG>> > doctors belonging to the same department cannot access their accounts ? AG>> No, this only means that the one to many relation has to be implemented AG>> as a one to one + query. AG>> AG>> > And at the same time, can't we list out all the doctors belonging to the AG>> > same department ? AG>> > AG>> You can, using a query : AG>> SELECT d FROM test.Detail d WHERE master=$1 AG>> AG>> I attached a new test case to demonstrate this. AG>> AG>> -- AG>> Mickael Guessant AG>> Technical Consultant AG>> http://mguessan.free.fr AG>> mailto:[EMAIL PROTECTED] AG>> AG> AG>----------------------------------------------------------- AG>If you wish to unsubscribe from this mailing, send mail to AG>[EMAIL PROTECTED] with a subject of: AG> unsubscribe castor-dev AG> -- perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");' ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
--
ARIJIT GHOSH
Software Engineer
SOFTEX Group
TECHNOPARK, TVM
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
--
Mickael Guessant
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
