C#Öе÷ÓÃOracle´æ´¢¹ý³Ì
¿Í»§»·¾³£ºVS2008+Oracle9i
·þÎñÆ÷Êý¾Ý¿â£ºOracle9i
Óöµ½Ò»¸öÎÊÌâ:¿Í»§¶Ë³ÌÐòÖÐÒªµ÷Ó÷þÎñÆ÷ÉϵĴ洢¹ý³Ì¡£ÎÒʹÓÃADO.NETµ÷ÓÃʱϵͳÌáʾ²ÎÊýÀàÐÍ»òÕß²ÎÊý¸öÊý²»ÕýÈ·¡£ÎÒ¼ì²éÒÔºóûÓз¢ÏÖÀàÐÍ´íÎó»òÕß²ÎÊý¸öÊý²»¶Ô¡£
ÓÚÊÇʹÓÃOracleµÄODAC×é¼þ£¨°æ±¾ºÅ-ODP.NET 9.2.0.7.00 £©µ÷ÓÃÒ²ÌáʾÓдíÎó¡£
ÒòΪ×öµ÷ÊÔµÄʱºò£¬»úÆ÷ÉÏ×°µÄÊÇoracle10g¿Í»§¶Ë,µ«ÎÒ³ÌÐòÀïÒýÓõÄdllÊÇOracle9iµÄ¡£Ê²Ã´ÔÒòÄØ£¿
ÏÖÔÚÓÖ¼¸µã²»Ã÷°×£º
1¡¢ÔÚʹÓÃADO.NETµ÷ÓÃOracle´æ´¢¹ý³ÌʱΪʲô³öÏÖ¡°²ÎÊýÀàÐÍ»òÕß²ÎÊý¸öÊý²»ÕýÈ·¡±Ìáʾ¡£
2¡¢Èç¹û»úÆ÷ÉÏͬʱװÓÐOracle10g¿Í»§¶ËºÍODP.NET 9.2.0.7.00·ÃÎÊ×é¼þ£¬¶Ô³ÌÐòÖе÷Óô洢¹ý³ÌÓÐûÓÐʲôӰÏì¡£
3¡¢»¹ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÉÏÊöÎÊÌâ¡£
Ã÷°×µÄÐÖµÜÃǰï°ï棡
ÎÒÊǰɿͻ§¶Ëɾ³ýÁË£¬ÓõÄODAC 11GµÄ°æ±¾
´æ´¢¹ý³ÌÄÇÎÊÌâ²»Çå³þ
´æ´¢¹ý³ÌÖØÐ±àÒëÏ¡£¡£¶à°ë»¹ÊDzÎÊý²»ÕýÈ·£¬ÖðÒ»¼ì²é°É¡£
°æ±¾²»Ò»ÖÂ
¿Í»§¶ËÒª°²×°
³ÌÐòÖеIJÎÊýºÍ´æ´¢¹ý³ÌÖеIJÎÊýÃûÊÇÒªÒ»ÑùµÄ
Ïà¹ØÎÊ´ð£º
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÏÈ˵Ã÷Ò»ÏÂÇé¿ö£ºÓÐÒ»¸örec1.batµÃÅú´¦ÀíÎļþÀï±ß´úÂëÈçÏ£º
SET ORACLE_SID=TosmecDB
sqlPLUS /nolog "@c:\tosmec\sys\syscom\TosmecHotSub1.sql"
TosmecHotSub1.sqlµÄÎļþÄÚÈÝÈçÏ ......