hibernateÖÐoracleµÄ×ÔÔöÎÊÌ⣺
Ò»Ö±ÒÔΪ <id name="id" type="integer">
<column name="ID" precision="5" scale="0" />
<generator class="sequence"¡¡/>
</id> ÕâÑù¾Í¿ÉÒÔ×ÔÔöÁË¡£¡£
¿É½ñÌìÔÚ²âÊÔʱ£¬·¢ÏÖ¿ØÖÆÌ¨Ò»Ö±±¨“ÐòÁкŲ»´æÔÚ"µÄ´í¡£¡£¡£ºóÀ´²ÅÖªµÀÔÚsequenceºóÃæ»¹Òª¼ÓÉÏoracleÊý¾Ý¿âÀïÃæµÄ×ÔÔöµÄÃû×Ö¡£¡£
ÒÔÏÂÊǽâ¾öµÄ·½°¸£º
<id name="id" type="integer">
<column name="ID" precision="5" scale="0" />
<generator class="sequence">
<param name="sequence">nid</param>
</generator>
</id>
ÆäÖÐnidÊÇÎÒ×Ô¼ºÔÚoracleÀïÃæÐ´µÄÒ»¸ö×ÔÔöº¯Êý¡£¡£¡£
Ïà¹ØÎĵµ£º
ʹÓÃÄ£ºý²éѯ£º
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd");
Date startdate = sdf.parse(start_date);
Date enddate = sdf.parse(end_date);
List list = sess.createCriteria(MyTabel.class)
.add( ......
ORACLE RAC¹¤×÷ÔÀí
ORACLE RAC¹¤×÷ÔÀí
¡¡¡¡ÔÚÒ»¸öÓ¦Óû·¾³µ±ÖУ¬ËùÓеķþÎñÆ÷ʹÓú͹ÜÀíͬһ¸öÊý¾Ý¿â£¬Ä¿µÄÊÇΪÁË·Öɢÿһ̨·þÎñÆ÷µÄ¹¤×÷Á¿£¬Ó²¼þÉÏÖÁÉÙÐèÒªÁ½Ì¨ÒÔÉϵķþÎñÆ÷£¬¶øÇÒ»¹ÐèÒªÒ»¸ö¹²Ïí´æ´¢É豸¡£Í¬Ê±»¹ÐèÒªÁ½ÀàÈí¼þ£¬Ò»¸öÊǼ¯ÈºÈí¼þ£¬ÁíÍâÒ»¸ö¾ÍÊÇOracleÊý¾Ý¿âÖеÄRAC×é¼þ¡£Í¬Ê±ËùÓзþÎñÆ÷ÉϵÄOS¶¼Ó¦¸ÃÊÇÍ ......
²éѯ±íempÖÐËùÓÐÊý¾Ý
select emp_id,rownum from emp
µÚÒ»²½£¬²éѯ½á¹û,rownum´ý¶¨
emp_id rownum
1 ? 1
2 ? 2
3 ? 3
4&n ......
Ä¿±ê£ºÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£¬Ö»Òª»á¼òµ¥µÄlinuxÃüÁî¾ÍÄÜʵÏÖoracle expµÄ×Ô¶¯±¸·Ý
»·¾³£ºlinux as3+oracle9i
¾ßÌåµÄ²½Ö裺
1.ÓʼþÉèÖÃ
[root@sxapp1 mail]# cd /etc/mail
[root@sxapp1 mail]# mv submit.cf submit.cfbak
[root@sxapp1 spool]# chmod a+wrx mqueue/
[root@sxapp1 mail]# echo "sdsd ......