Nyilván, ez csak akkor jó, ha rövid időre kell a lock. Amúgy a tranzakció izolációs szint is pont erre van kitalálva.<div><br></div><div>Ha akár hosszú percekre is szeretnél lokkolni rekordokat, akkor egyik sem túl szerencsés.</div><div><br></div><div>Üdv</div><div> Zs<br><div><br>On Fri Sep 14 12:15:42 GMT+200 2012, Keresztes Jozsef <jkeresztes@vati.hu>. wrote:<br><br><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="WordSection1"><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">Vagyis konkrétan ezt kell csinálni:<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""><o:p> </o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:Courier;color:blue;background:white;mso-highlight:white;mso-fareast-language:EN-US">lock</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;background:white;mso-highlight:white;mso-fareast-language:EN-US"> </span><span lang="EN-US" style="font-size:10.0pt;font-family:Courier;color:blue;background:white;mso-highlight:white;mso-fareast-language:EN-US">table</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;background:white;mso-highlight:white;mso-fareast-language:EN-US"> szemafor </span><span lang="EN-US" style="font-size:10.0pt;font-family:Courier;color:blue;background:white;mso-highlight:white;mso-fareast-language:EN-US">in</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;background:white;mso-highlight:white;mso-fareast-language:EN-US"> </span><span lang="EN-US" style="font-size:10.0pt;font-family:Courier;color:blue;background:white;mso-highlight:white;mso-fareast-language:EN-US">exclusive</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;background:white;mso-highlight:white;mso-fareast-language:EN-US"> </span><span lang="EN-US" style="font-size:10.0pt;font-family:Courier;color:blue;background:white;mso-highlight:white;mso-fareast-language:EN-US">mode;</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;background:white;mso-highlight:white;mso-fareast-language:EN-US"><o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;background:white;mso-highlight:white;mso-fareast-language:EN-US">update table_a …;<o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;background:white;mso-highlight:white;mso-fareast-language:EN-US">insert into table_b …;<o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;background:white;mso-highlight:white;mso-fareast-language:EN-US">…<o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:Courier;color:blue;background:white;mso-highlight:white;mso-fareast-language:EN-US">commit;<o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:Courier;color:blue;background:white;mso-highlight:white;mso-fareast-language:EN-US"><o:p> </o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:Courier;color:blue;background:white;mso-highlight:white;mso-fareast-language:EN-US">Jelöljetek ki egy táblát (a példában “szemafor”), de lehet máshogy is…<o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:Courier;color:blue;background:white;mso-highlight:white;mso-fareast-language:EN-US"><o:p> </o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:Courier;color:blue;background:white;mso-highlight:white;mso-fareast-language:EN-US">Joe</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;background:white;mso-highlight:white;mso-fareast-language:EN-US"><o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""><o:p> </o:p></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""><o:p> </o:p></span></p><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Vig, Balázs [mailto:balazs.vig@datasolutions.hu] <br><b>Sent:</b> Friday, September 14, 2012 12:05 PM<br><b>To:</b> Java lista<br><b>Subject:</b> [Javalist] Adatbázis lock<o:p></o:p></span></p><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal" style="margin-bottom:12.0pt">Sziasztok!<br><br>Van egy Hibernate alapú kliensem, ami több példányban is futhat. A kliens feladata, hogy az adatbázis objektumokon műveleteket végezzen.<br>Hogyan lehet azt garantálni, hogy egy objektummal csak az egyik kliens foglalkozhasson: ha az egyik már elkezdett dolgozni rajta, akkor másik már ne tudjon.<br><br>Támogatja-e ezt valahogy a hibernate, vagy a jdbc? (eddig nem találtam erre semmit). Vagy nekem kell valami mókolnom az adatbázisban?<br clear="all"><br>Üdv:<br><b>Vig Balázs<br><br></b><o:p></o:p></p></div>_______________________________________________
<br>Javalist mailing list
<br><a onclick="mailTo('Javalist@lists.javaforum.hu');return false;" href="mailto:Javalist@lists.javaforum.hu">Javalist@lists.javaforum.hu</a>
<br><a onclick="openLink('http://lists.javaforum.hu/mailman/listinfo/javalist');return false;" href="http://lists.javaforum.hu/mailman/listinfo/javalist">http://lists.javaforum.hu/mailman/listinfo/javalist</a>
<br></blockquote></div></div>