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Êý¾Ý¿âʱ»á±¨´í¡£
Ïà¹ØÎĵµ£º
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
1£¬segments µÄ·ÖÀà
l
Êý¾Ý¶Î
l
Ë÷Òý¶Î
l
ÁÙʱ¶Î
l
»ØÍË ......
Õâ¶Îʱ¼äΪ¹«Ë¾ÄÚ²¿µÄÊý¾Ý´¦Àí¿ª·¢ÁËÒ»¸ö¹¤¾ß£¬Ç£Éæµ½ÔÚOracleÖм¯³ÉjavaÓ¦Óã¬×ܽáÁËһЩ¾Ñ飬ÒÔ¹©´ó¼Ò²Î¿¼ÁË£¡
³ÌÐò·ÖÁ½²¿·Ö£¬Ç°¶Ë½çÃæÓÉVB/VC¿ª·¢£¬Ö÷ҪʵÏÖÊý¾Ý´¦ÀíÅäÖü°³£¹æ¼Ç¼ÔËË㣬Õⲿ·ÖûÓÐʲôºÃ˵µÄÁË¡£
ºǫ́ÒÔOracleΪÊý¾Ý»ù´¡´¦ÀíÍйÜƽ̨£¬ÔÚÊý¾Ý´¦Àí¹ý³ÌÖУ¬ÐèÒª¶ÔһЩÃû³Æ¡¢µØַʲôµÄ½øÐÐÕªÒªÌáÈ¡¡¢² ......
sqlldrÏê½â
Oracle µÄSQL*LOADER¿ÉÒÔ½«ÍⲿÊý¾Ý¼ÓÔص½Êý¾Ý¿â±íÖС£ÏÂÃæÊÇSQL*LOADERµÄ»ù±¾Ìص㣺
1£©ÄÜ×°È벻ͬÊý¾ÝÀàÐÍÎļþ¼°¶à¸öÊý¾ÝÎļþµÄÊý¾Ý
2£©¿É×°Èë¹Ì¶¨¸ñʽ£¬×ÔÓɶ¨½çÒÔ¼°¿É¶È³¤¸ñʽµÄÊý¾Ý
3£©¿ÉÒÔ×°Èë¶þ½øÖÆ£¬Ñ¹ËõÊ®½øÖÆÊý¾Ý
4£©Ò»´Î¿É¶Ô¶à¸ö±í×°ÈëÊý¾Ý
5£©Á¬½Ó¶à¸öÎïÀí¼Ç¼װµ½Ò»¸ö¼Ç¼ÖÐ
6£©¶ÔÒ ......
1. trigger ÊÇ×Ô¶¯Ìá½»µÄ£¬²»ÓÃCOMMIT£¬ROLLBACK
2. trigger×î´óΪ32K£¬Èç¹ûÓи´ÔÓµÄÓ¦ÓÿÉÒÔͨ¹ýÔÚTRIGGERÀïµ÷ÓÃPROCEDURE»òFUNCTIONÀ´ÊµÏÖ¡£
3. Óï·¨
CREATE OR REPLACE TRIGGER <trigger_name>
<BEFORE | AFTER> <ACTION>
ON <table_name>
DECLARE
<variable definitions> ......