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
Ïà¹ØÎÊ´ð£º
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......
oracle°²×°Ê±£¬ÔÚ½øÐмì²âʱ£¬ÌáÊ¾ÍøÂç¼à²âδ³É¹¦£¬ÐèÒª°²×°ÐéÄâÍø¿¨
µ«ÊÇÎÒÃǰ칫ÊÒͬÑùÅäÖõÄÁ½Ì¨µçÄÔ£¬ÎªÊ²Ã´Ò»Ì¨³öÏÖÍøÂç¼à²âδ³É¹¦£¬¶øÁíһ̨»ú×Ó¾ÍûÓгöÏÖÕâÖÖÇé¿ö
ÔÚʲôÇé¿öÏ£¬»á³öÏÖÍøÂç¼à ......
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......
sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬
ÀýÈç sqlplus /nolog
conn system/oracle£¨ÃÜÂ룩
Õâ¸öÁ¬½ÓOracleµÄÕû¸ö»úÖÆÊÇʲô£¨×¢ÖØÓÚÁ¬½ÓµÄÔÀíÉÏ£©
Èç¹ûÓÐ˶®»òÓÐÏà¹ØÄÚÈݸøÓèÌáÊ ......