Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¹éµµ¹ÜÀí

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

ÀûÓÃoracleÉó¼Æ¹¦ÄÜÀ´¼à¿Ø²âÊÔÊý¾Ý¿âµÄ±ä»¯

ÀûÓÃoracleÉó¼Æ¹¦ÄÜÀ´¼à²âÊÔ»·¾³µÄ±ä»¯
         ×ö¹ý²âÊÔµÄÈ˶¼Ó¦¸Ã»áÅöµ½ÕâÑùµÄÇé¿ö£º²âÊÔ·¢ÏÖµÄbugÔÚ¿ª·¢»úÆ÷ÉÏûÓгöÏÖ£¬ÏÔÈ»ÕâÊÇ»·¾³²îÒìµÄÔ­Òò¡£Ï൱¶àÇé¿öÏ£¬ÒòΪ²âÊÔʹÓõÄÊý¾Ý¿â½á¹¹ºÍ¿ª·¢Ê¹ÓõÄÊý¾Ý¿â½á¹¹²»Ò»ÖÂÔì³ÉµÄ¡£ÓÈÆäÊÇһЩ¹«Ë¾ÔÚÌá½»²âÊÔ°æ±¾µÄʱºò£¬×¢ÖØÓ¦Óà ......

Oracle Êý¾ÝÀàÐÍ·ÖÏí

¸øÍŶÓÄÚ²¿×öµÄÒ»¸öOracle Êý¾ÝÀàÐÍ·ÖÏí£¬Ö÷ÒªÊǹØÓÚOracleÊý¾ÝÀàÐÍһЩÄÚ²¿´æ´¢½á¹¹¼°ÐÔÄܽéÉÜ¡£
 http://www.slideshare.net/yzsind/oracle-4317768
ÒÔÏÂÊÇPPTÖÐunDumpNumberº¯ÊýµÄÈ«²¿´úÂ룺
 
create or replace function unDumpNumber(iDumpStr varchar2) return number is
 
  TYPE ByteAr ......

oracle µ¼Èë

sqlldrÏê½â
 
Oracle µÄSQL*LOADER¿ÉÒÔ½«ÍⲿÊý¾Ý¼ÓÔص½Êý¾Ý¿â±íÖС£ÏÂÃæÊÇSQL*LOADERµÄ»ù±¾Ìص㣺
1£©ÄÜ×°È벻ͬÊý¾ÝÀàÐÍÎļþ¼°¶à¸öÊý¾ÝÎļþµÄÊý¾Ý
2£©¿É×°Èë¹Ì¶¨¸ñʽ£¬×ÔÓɶ¨½çÒÔ¼°¿É¶È³¤¸ñʽµÄÊý¾Ý
3£©¿ÉÒÔ×°Èë¶þ½øÖÆ£¬Ñ¹ËõÊ®½øÖÆÊý¾Ý
4£©Ò»´Î¿É¶Ô¶à¸ö±í×°ÈëÊý¾Ý
5£©Á¬½Ó¶à¸öÎïÀí¼Ç¼װµ½Ò»¸ö¼Ç¼ÖÐ
6£©¶ÔÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ