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

ÔÚhibernateÖÐʵÏÖoracleµÄÖ÷¼ü×ÔÔö²ßÂÔ

ת×Ô£ºhttp://blog.csdn.net/scorpio3k/archive/2009/05/09/4162079.aspx
 ÔںܶàÇé¿öÏ£¬ÎÒÃÇʹÓÃHibernateÔÚÒѾ­½¨Á¢ºÃÊý¾Ý¿âµÄ»ù´¡ÉÏ¡£ÔÚoracleÖУ¬Èç¹ûÒѾ­½¨Á¢ºÃµÄÊý¾Ý¿âÖÐʹÓÃÁËsequence
,Ôò¿ÉÒÔ°´ÕÕÏÂÃæµÄ²½Öè°ÑËüÒýÈëµ½HibernateÖУº
   
   1¡¢ÔÚoracle Ê×ÏÈ´´½¨sequence
      
create sequence seq_id
      minvalue 1
      start with 1
      increment by 1
      cache 20;
   2.ÔÚÄãµÄhbm.xmlÖеÄÅäÖÃ
   
     <id column="ID0000" name="id" type="integer">
         <generator class="sequence">
              <param name="sequence">seq_id</param>
         </generator>
     </id>
   ÕâÑùÔÙ²åÈëÊý¾ÝµÄʱºò£¬Hibernate»Ø×Ô¶¯Éú³ÉÈçÏÂÓï¾ä£º
   
   hibernate
: select seq_id.nextval from dual
   hibernate
:  insert into YXJK.T_YXJK_WHRYTXL (XM0000, ZW0000, LXDH00, SJHM00, DZYJ00,   
                    IP0000,     ID0000) values (?, ?, ?, ?, ?, ?, ?)
   ×Ô¶¯Éú³ÉÏÂÒ»¸öÐòÁÐÖµ£¬È»ºó½«¶ÔÏó²åÈë±íÖС£
   ÔÚʹÓõÄʱºòÐèҪעÒ⣬Hibernate¶ÔÓÚsequenceµÄÖ÷¼üµÄÒªÇóÊÇÒ»¶¨ÒªÊÇshor,long£¬»òÕßinteger
¸ù¾ÝhibernateµÄÎĵµ£¬ÓÐÁ½ÖÖ·½Ê½ÊµÏÖʵÌå¶ÔÏóµÄÖ÷¼ü×Ô¶¯Ôö³¤¡£
µÚÒ»ÖÖ£ºÉèÖÃIDµÄÔö³¤²ßÂÔÊÇsequence£¬Í¬Ê±Ö¸¶¨sequenceµÄÃû×Ö£¬×îºÃÿ¸ö±í½¨Ò»¸ösequence£¬´ËÖÖ×ö·¨¾ÍÈçͬMS-SQL,MY-SQLÖеÄ×Ô¶¯Ôö³¤Ò»Ñù£¬²»ÐèÒª´´½¨´¥·¢Æ÷£¬¾ßÌåµÄoracleÊý¾Ý¿â½Å±¾¼°hibernateÅäÖÃÎļþÈçÏ£º
[1]or


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

install oracle 10.0.2.0.4 on mac10.5.8

¾­¹ýÁ½ÌìµÄµ¹ÌÚÖÕÓÚÔÚmacÉÏ×°ºÃoracle10g ÁË¡£ÕâÏÂÍêÃÀÁË++
½Ì³ÌÍøÉÏÓкܺã¬×Ô¼ºÒ²²»¼ÇµÃ²ÎÕÕ¹ý¶àÉÙÆªÁË¡£
Ö»¼ÇÏÂ×Ô¼ºÅöµ½µÄÎÊÌâµã¡£
1,×éÎÊÌâ¡£
  ÍêÈ«ÊǸöÈËʹÓã¬ËùÒÔÎÒûÓл¨ÄǸöÏй¤·òȥн¨Ò»´ó¶Ñ×éºÍÓû§£¬
 Ïà·´£¬ÎÒ¾ÍÊÇÄõ±Ç°Óû§×°µÄ£¬Ö»²»¹ý£¬°Ñµ±Ç°Óû§Ò²¼ÓÈëÁËROOT×飬Õâ¸ö±È½ÏºÝ¡£
2£¬ÓеĽ ......

oracle rownumµÄÓ÷¨


Õª×Ô¡¶½âÎöoracleµÄrownum¡·×÷Õߣºchen_liang
¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖÆ²éѯ·µ»ØµÄ×ÜÐÐÊý£¬ÇÒrownum²»ÄÜÒÔÈκαíµÄÃû³Æ×÷Ϊǰ׺¡£
(1) rownum ¶ÔÓÚµÈÓÚijֵµÄ²éѯÌõ¼þ
Èç¹ûÏ£ÍûÕÒµ½Ñ§Éú±íÖеÚÒ»ÌõѧÉúµÄÐÅÏ¢ ......

ÔÚubuntu ϰ²×°Oracle 11g

root@hardy:~# cd /bin
root@hardy:/bin# ls -l /bin/sh
lrwxrwxrwx 1 root root 4 2008-04-28 19:59 /bin/sh -> dash
root@hardy:/bin# ln -sf bash /bin/sh
root@hardy:/bin# ls -l /bin/sh
lrwxrwxrwx 1 root root 4 2008-05-01 22:51 /bin/sh -> bash
# echo "Red Hat Linux release 4" > /etc/redhat- ......

oracle ÀûÓýű¾½¨¿â

£±£º´´½¨»·¾³±äÁ¿
¡¡¡¡export $ORACLE_HOME $ORACLE_SID£¨×¼±¸½¨Á¢µÄÊý¾Ý¿âµÄSID)
£²£º½¨Á¢³õʼ»¯²ÎÊýÎļþ
¡¡¡¡$ORACLE_HOME/dbs/init$ORACLE_SID.ora (¿ÉÒÔ´ÓÒѾ­½¨ºÃµÄ¿âÀïÃæÄÃ,ͨ³£ÔÚpfile ÀïÃæ£©,Ò²¿ÉÒÔ×Ô¼º½¨£º
¡¡¡¡control_files = ($ORACLE_HOME/oradata/$ORACLE_SID/control1.ctl,$ORACLE_HOME/oradata/$ORACLE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ