Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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, high water mark)ÎÊÌâ

Oracle¶Ô±í×öÈ«±íɨÃèµÄʱºò
£¬»áɨÃèÍêHWMÒÔÏÂ
µÄÊý¾Ý¿é¡£Èç¹ûij¸ö±ídelete(delete²Ù×÷²»»á½µµÍ¸ßˮλ)ÁË´óÁ¿Êý¾Ý£¬ÄÇôÕâʱ¶Ô±í×öÈ«±íɨÃè¾Í»á×öºÜ¶àÎÞÓù¦£¬É¨ÃèÁËÒ»´ó¶ÑÊý¾Ý¿é£¬×îºó·¢ÏÖ¿éÀïÃæ¾ÓȻûÓÐÊý¾Ý¡£
ͨ³££¬ÔÚ¶Ô±í×öÁË´óÅúÁ¿delete²Ù×÷Ö®ºó£¬¾ÍÓ¦¸ÃÂíÉϽµµÍ±íµÄ¸ßˮ룬¿ÉÒÔʹÓÃshrink ÃüÁî»òÕßalter&n ......

oracleÖеÄsavepointsÊÇʲô

ʲôÊÇ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¹éµµ¹ÜÀí

     Oracle°ÑÌîÂúµÄÁª»úÈÕÖ¾Îļþ¸´ÖƵ½Ò»¸ö»òÕ߶à¸ö·¾¶£¬Õâ¸ö¹ý³Ì½Ð¹éµµ£¬ÕâÑùÉú³ÉµÄÎļþ½Ð¹éµµÈÕÖ¾Îļþ£¬´æ·ÅÈÕÖ¾ÎļþµÄ·¾¶½Ð¹éµµÂ·¾¶£¨¹éµµÄ¿Â¼£©¡£Ò»¸öÊý¾Ý¿â¿ÉÒÔÓжà¸ö¹éµµ½ø³Ì£¬Óɳõʼ»¯²ÎÊýLOG_ARCHIVE_MAX_PROCESSES)¿ØÖÆ¡£¹éµµÊDZ¸·ÝºÍ»Ö¸´µÄ»ùʯ¡£ÔÚOracleÖУ¬¼¸ºõËùÓеı¸·ÝºÍ»Ö¸´¶¼ÊÇÒѹ ......

ÔÚOracleÖм¯³Éjava³ÌÐòµÄ¾­Ñé̸֮£¡

Õâ¶Îʱ¼äΪ¹«Ë¾ÄÚ²¿µÄÊý¾Ý´¦Àí¿ª·¢ÁËÒ»¸ö¹¤¾ß£¬Ç£Éæµ½ÔÚOracleÖм¯³ÉjavaÓ¦Óã¬×ܽáÁËһЩ¾­Ñ飬ÒÔ¹©´ó¼Ò²Î¿¼ÁË£¡
³ÌÐò·ÖÁ½²¿·Ö£¬Ç°¶Ë½çÃæÓÉVB/VC¿ª·¢£¬Ö÷ҪʵÏÖÊý¾Ý´¦ÀíÅäÖü°³£¹æ¼Ç¼ÔËË㣬Õⲿ·ÖûÓÐʲôºÃ˵µÄÁË¡£
ºǫ́ÒÔOracleΪÊý¾Ý»ù´¡´¦ÀíÍйÜƽ̨£¬ÔÚÊý¾Ý´¦Àí¹ý³ÌÖУ¬ÐèÒª¶ÔһЩÃû³Æ¡¢µØַʲôµÄ½øÐÐÕªÒªÌáÈ¡¡¢² ......

¹ØÓÚOracleÊý¾Ýµ¼Èëµ¼³öµÄһЩ²Ù×÷

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ