¹ØÓÚSQL ServerËÀËø
transaction 1:
------------------------------------------------------
begin transaction
update table1 set cola = 'str1'
Waitfor time '10:12:00'
update table2 set colb = 'str2'
rollback transaction
transaction 2:
------------------------------------------------------
begin transaction
update table2 set colb = 'str2'
Waitfor time '10:12:00'
update table1 set cola = 'str1'
rollback transaction
ͬʱÔËÐÐÕâÁ½¸öÊÂÎñ£¬½«µ¼ÖÂËÀËø¡£(ÏÈ´´½¨table1ºÍtable2£¬²¢²åÈëһЩֵ£»waitfor time Êʵ±ÐÞ¸Ä)
SQL Server±¾Éí»á´¦ÀíËÀËø£¬Í¨¹ýÑ¡ÔñÒ»¸öËÀËøÎþÉüÆ·£¬»Ø¹öËÀËøÎþÉüÆ·µÄÊÂÎñ£¬À´±ÜÃâËÀËø¡£
SQL ServerÔÚÉÏÃæÕâÁ½¸öÊÂÎñÖÐ×Ô¶¯Ñ¡ÔñÒ»¸ö×÷ΪËÀËøÎþÉüÆ·£¬¸ÃÊÂÎñ½«ÊÕµ½ÈçÏÂÏûÏ¢£º
------------------------------------------------------
Msg 1205, Level 13, State 56, Line 7
ÊÂÎñ(½ø³Ì ID 52)ÓëÁíÒ»¸ö½ø³Ì±»ËÀËøÔÚ Ëø ×ÊÔ´ÉÏ£¬²¢ÇÒÒѱ»Ñ¡×÷ËÀËøÎþÉüÆ·¡£ÇëÖØÐÂÔËÐиÃÊÂÎñ¡£
SQL ServerÑ¡ÔñËÀËøÎþÉüÆ·¸ù¾ÝµÄÊÇ´ú¼Û×îСÔÔò£¬Óû§Ò²¿ÉÒÔͨ¹ýÉèÖÃDEADLOCK_PRIORITYÑ¡Ïî½øÐиÉÔ¤¡£
ÀýÈ磬ÔÚÊÂÎñ1 set DEADLOCK_PRIORITY low£¬ÔÚÊÂÎñ2 set DEADLOCK_PRIORITY high£¬Ôò·¢ÉúËÀËøʱSQL Server½«Ñ¡ÔñÊÂÎñ1×÷ΪËÀËøÎþÉüÆ·¡£
ÈçºÎ±ÜÃâËÀËø£º
1. ¶à¸ö²¢·¢ÊÂÎñ°´ÕÕͬÑùµÄ˳Ðò·ÃÎʶÔÏó
2. ÔÚÊÂÎñÖбÜÃâÓû§½»»¥
3. ¾¡Á¿Ëõ¶ÌÊÂÎñµÄÖ´ÐÐʱ¼ä£¬¿Í»§¶Ë²»Ó¦°ÑÒ»¸öÊÂÎñ·Ö³É¶à´Î·¢ËÍ¡£
4. ÉèÖøüµÍµÄ¸ôÀ뼶±ð
5. ʹÓÃÀ¦°óÁ¬½Ó
Ïà¹ØÎĵµ£º
CareGroup Ò½ÁÆ×éÖ¯¸ºÔð±£»¤2TB µÄ²¡ÈËÐÅÏ¢ºÍÏà¹ØÊý¾ÝµÄÒþ˽¼°ÍêÕûÐÔ¡£¸Ã×é֯λÓÚ²¨Ê¿¶Ù£¬ÊÇBeth Israel Deaconess ҽѧÖÐÐÄ£¨¹þ·ðҽѧԺµÄ½ÌѧҽԺ£©ÒÔ¼°ÁíÍâÈý¼ÒµØÇøÒ½ÔºµÄĸ¹«Ë¾¡£CareGroup ²ÉÓÃMicrosoft® SQL Server™ 2005£¬½«ÆäÊý¾Ý´æ´¢ÓÚ30¸öʵÀýµÄ390¸öÊý¾Ý¿âÖС£¸Ã×é֯ϣÍû½«Êý¾Ý¿âÉý¼¶µ½SQL Server 200 ......
CyberSavvy ¼áÐÅÈí¼þ×Ô¶¯»¯¿ÉÒÔÈÿͻ§ÇáËÉÏíÊÜÉú»î¡£DataPlace ÊǸù«Ë¾µÄÈí¼þ¼´·þÎñ½â¾ö·½°¸£¬Ò²¿É³Æ֮Ϊ“Êý¾Ý¿â¹¤³§”£¬ËüÄܹ»ÈÃÃæÏò¼¼ÊõÒÔ¼°ÃæÏòÉÌÎñµÄÓû§´´½¨²¢ÐÞ¸Ä×Ô¼ºµÄÊý¾Ý¿â£¬¶øCyberSavvy ¹«Ë¾½«Îª¸ÃÊý¾Ý¿âÌṩÍйܷþÎñ¡£Òò´ËCyberSavvy ¹«Ë¾ÐèÒªÅÍʯ°ã¼á¹ÌµÄÊý¾Ý¿â£¬²¢Í¨¹ýÍòÎÞһʧµÄÊý¾Ý´«Êä»úÖÆÀ´Ö ......
1.½¨±íÓï¾ä£ºcreate table
Ó÷¨: create table ±íµÄÃû×Ö (×Ö¶Î1, ×Ö¶Î2,¡£¡£¡£¡£)
¾ÙÀý£ºÀýÈç´´½¨Ò»¸öѧÉú³É¼¨±í£¬°üº¬µÄ×Ö¶ÎÓУ¬Ñ§Éúid£¬ÐÕÃû£¬ÐԱ𣬰༶£¬³É¼¨create table score(
create table score(
sid nvarchar(10) primary key,
sname nvarchar(10) not null,
sex nvarchar(2),
sc ......
ºÍjava.lang.IllegalArgumentException: org.hibernate.QueryException: JPA-style positional param was not an integral ordinalÕ½¶·ÁË°ëÌ죬º¹°¡£¡
ʹÓÃjpa + strut+ hibernate ¾Í±¨org.hibernate.QueryException: JPA-style positional param was not an integral ordinal
Ò»°ã°ÑhqlÓï¾äдÔÚÒ»ÐУ¬»áºÜ³¤£¬ÔÚideÖÐÐèÒ ......
select top ÿҳÏÔʾµÄ¼Ç¼Êý * from topic where id not in (select top £¨µ±Ç°µÄÒ³Êý-1£©×ÿҳÏÔʾµÄ¼Ç¼Êý id from topic order by id desc) order by id desc
select top ÿҳÏÔʾµÄ¼Ç¼Êý * from topic where id not in (select top £¨µ±Ç°µÄÒ³Êý-1£©×ÿҳÏÔʾµÄ¼Ç¼Êý id from topic order by id desc) ......