hibernate Oracle sequenceÎÊÌâ
ÏÖÔÚÊÇÕâÑùµÄ¡£ÎÒ±íÖеÄÖ÷¼üÊÇjjdm,µ«oracleʹÓÃÁËÖ÷¼û ¾Í±ØÐëÒªÓÐsequence¡£ÎҾͽ¨ÁËÒ»¸ö¡£µ«hbm.xml ÔõôÅäÖÃÄØ
<id name="id" type="java.lang.Integer">
<column name="ID" length="8" precision="22" scale="0"/>
<generator class="sequence">
<param name="sequence"/>
</generator>
</id>
<property name="jjdm" type="java.lang.String">
<column name="JJDM" length="10"/>
</property>
µ«hbmÎļþÖÐ <id> </id>²ÅÊÇÖ¸¶¨Ö÷¼üµÄ¡£¶øÎÒµÄJJDMÊÇÖ÷¼ü¡£Ó¦¸ÃÔõôÅäÖÃÄØ
¼±Çó............
<id name="jjdm" type="java.lang.Long">
<column name="JJDM" precision="22" scale="0" />
<generator class="sequence">
<param name="sequence">sequence_name </param>
&nbs
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
oracle°²×°Ê±£¬ÔÚ½øÐмì²âʱ£¬ÌáÊ¾ÍøÂç¼à²âδ³É¹¦£¬ÐèÒª°²×°ÐéÄâÍø¿¨
µ«ÊÇÎÒÃǰ칫ÊÒͬÑùÅäÖõÄÁ½Ì¨µçÄÔ£¬ÎªÊ²Ã´Ò»Ì¨³öÏÖÍøÂç¼à²âδ³É¹¦£¬¶øÁíһ̨»ú×Ó¾ÍûÓгöÏÖÕâÖÖÇé¿ö
ÔÚʲôÇé¿öÏ£¬»á³öÏÖÍøÂç¼à ......
sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬
ÀýÈç sqlplus /nolog
conn system/oracle£¨ÃÜÂ룩
Õâ¸öÁ¬½ÓOracleµÄÕû¸ö»úÖÆÊÇʲô£¨×¢ÖØÓÚÁ¬½ÓµÄÔÀíÉÏ£©
Èç¹ûÓÐ˶®»òÓÐÏà¹ØÄÚÈݸøÓèÌáÊ ......