dz̸ÔÚHibernateÖÐʹÓÃOracle sequence
Ò». Ϊ±í´´½¨×ÔÔö³¤×Ô¶ÎÓÐÁ½ÖÖ£¬Ò»ÖÖÊDz»Í¬µÄ±íʹÓø÷×ÔµÄSequence£¬·½·¨ÈçÏ£º
1¡¢ÔÚOracle sequenceÊ×ÏÈ´´½¨sequence create sequence seq_idminvalue 1start with 1increment by 1cache 20; 2.ÔÚÄãµÄhbm.xmlÖеÄÅäÖà seq_id ÕâÑùÔÙ²åÈëÊý¾ÝµÄʱºò£¬Hibernate»á×Ô¶¯Éú³ÉÈçÏÂÓï¾ä£º hibernate: select seq_id.nextval from dualhibernate: insert into YXJK.T_YXJK_WHRYTXL (XM0000, ZW0000, LXDH00, SJHM00, DZYJ00, IP0000, ID0000) values (?, ?, ?, ?, ?, ?, ?) ×Ô¶¯Éú³ÉÏÂÒ»¸öÐòÁÐÖµ£¬È»ºó½«¶ÔÏó²åÈë±íÖС£ÔÚʹÓõÄʱºòÐèҪעÒ⣬Hibernate¶ÔÓÚsequenceµÄÖ÷¼üµÄÒªÇóÊÇÒ»¶¨ÒªÊÇshor,long£¬»òÕßinteger¡£ ¶þ »¹ÓÐÒ»ÖÖ·½Ê½ÊÇʹÓù«¹²µÄsequence Õâ¸÷ʱºò¿ÉÒÔ²»Ö¸¶¨±íʹÓõÄsequence£¬ÄÇôÏàÓ¦µÄhbm.xmlÖÐÄÚÈÝÊÇ£º È»ºó´´½¨¹«ÓÃµÄ sequence¶ÔÏó£¬ÃüÃûΪ hibernate_sequence create sequence hibernate_sequenceminvalue 0maxvalue 99999999start with 10000increment by 1; Èý ×¢ÒâÊÂÏî Èç¹ûÊý¾Ý¿âÊÇ´ÓsqlserverµÈÆäËûÊý¾Ý¿âÒÆÖ²¶øÀ´µÄ£¬ÄÇô´´½¨sequenceʱµÄÆðʼֵӦ¸Ã±Èµ±Ç°±íÖÐ×î´óµÄIDÖµ´ó£¬·ñÔò»á³öÏÖ´íÎó£¬ÒòΪsequence ²»»áά»¤ÊÇ·ñºÍµ¼¿âÇ°ÏÖÓеÄÖµÖظ´¡£ 1¡¢sequence£ºÓÃÓÚOracleÊý¾Ý¿â ÐòÁÐÃû 2¡¢native£º¿çÊý¾Ý¿âʱʹÓã¬Óɵײ㷽ÑÔ²úÉú¡£
Default.sequenceΪhibernate_sequence ×¢£ºÊ¹ÓÃnativeʱHibernateĬÈÏ»áÈ¥²éÕÒOracleÖеÄhibernate_sequenceÐòÁС£Èç¹ûOracleÖÐûÓиÃÐòÁУ¬Á¬OracleÊý¾Ý¿âʱ»á±¨´í¡£
Ïà¹ØÎĵµ£º
Oracle¶Ô±í×öÈ«±íɨÃèµÄʱºò
£¬»áɨÃèÍêHWMÒÔÏÂ
µÄÊý¾Ý¿é¡£Èç¹ûij¸ö±ídelete(delete²Ù×÷²»»á½µµÍ¸ßˮλ)ÁË´óÁ¿Êý¾Ý£¬ÄÇôÕâʱ¶Ô±í×öÈ«±íɨÃè¾Í»á×öºÜ¶àÎÞÓù¦£¬É¨ÃèÁËÒ»´ó¶ÑÊý¾Ý¿é£¬×îºó·¢ÏÖ¿éÀïÃæ¾ÓȻûÓÐÊý¾Ý¡£
ͨ³££¬ÔÚ¶Ô±í×öÁË´óÅúÁ¿delete²Ù×÷Ö®ºó£¬¾ÍÓ¦¸ÃÂíÉϽµµÍ±íµÄ¸ßˮ룬¿ÉÒÔʹÓÃshrink ÃüÁî»òÕßalter&n ......
ʲôÊÇsavepoint?
Use the SAVEPOINT statement to identify a point in a transaction to which you can later roll back.
¸øÄã¸öÀý×Ó
SQL> create table test (id number(7));
±íÒÑ´´½¨¡£
SQL> insert into test values (3);
ÒÑ´´½¨ 1 ÐС£
SQL> savepoint a;
±£´æ ......
Oracle°ÑÌîÂúµÄÁª»úÈÕÖ¾Îļþ¸´ÖƵ½Ò»¸ö»òÕ߶à¸ö·¾¶£¬Õâ¸ö¹ý³Ì½Ð¹éµµ£¬ÕâÑùÉú³ÉµÄÎļþ½Ð¹éµµÈÕÖ¾Îļþ£¬´æ·ÅÈÕÖ¾ÎļþµÄ·¾¶½Ð¹éµµÂ·¾¶£¨¹éµµÄ¿Â¼£©¡£Ò»¸öÊý¾Ý¿â¿ÉÒÔÓжà¸ö¹éµµ½ø³Ì£¬Óɳõʼ»¯²ÎÊýLOG_ARCHIVE_MAX_PROCESSES)¿ØÖÆ¡£¹éµµÊDZ¸·ÝºÍ»Ö¸´µÄ»ùʯ¡£ÔÚOracleÖУ¬¼¸ºõËùÓеı¸·ÝºÍ»Ö¸´¶¼ÊÇÒѹ ......
Õâ¶Îʱ¼äΪ¹«Ë¾ÄÚ²¿µÄÊý¾Ý´¦Àí¿ª·¢ÁËÒ»¸ö¹¤¾ß£¬Ç£Éæµ½ÔÚOracleÖм¯³ÉjavaÓ¦Óã¬×ܽáÁËһЩ¾Ñ飬ÒÔ¹©´ó¼Ò²Î¿¼ÁË£¡
³ÌÐò·ÖÁ½²¿·Ö£¬Ç°¶Ë½çÃæÓÉVB/VC¿ª·¢£¬Ö÷ҪʵÏÖÊý¾Ý´¦ÀíÅäÖü°³£¹æ¼Ç¼ÔËË㣬Õⲿ·ÖûÓÐʲôºÃ˵µÄÁË¡£
ºǫ́ÒÔOracleΪÊý¾Ý»ù´¡´¦ÀíÍйÜƽ̨£¬ÔÚÊý¾Ý´¦Àí¹ý³ÌÖУ¬ÐèÒª¶ÔһЩÃû³Æ¡¢µØַʲôµÄ½øÐÐÕªÒªÌáÈ¡¡¢² ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
......