Python Á¬½Ó Oracle Êý¾Ý¿â
¸÷λºÃ£¬Ð¡µÜÎÒÓöµ½Ò»¸öÎÊÌ⣬ÎÒÊÔ×ÅÓÃPython´ÓÎÒµÄLinuxÉÏÈ¥Á¬½Óһ̨Զ³ÌµÄOracleÊý¾Ý¿â·þÎñÆ÷£¬È»ºóÔÚÍøÉÏÕÒÁËÒ»¸ö½Ð×öcx_OracleµÄÒ»¸ölib£¬¿ÉÔÚÎÒÖ´ÐÐsetup³ÌÐòµÄʱºò±¨ÁËÒ»¸ö´í£º
Traceback (most recent call last):
File "setup.py", line 123, in ?
raise DistutilsSetupError("cannot locate an Oracle software " \
distutils.errors.DistutilsSetupError: cannot locate an Oracle software installation
ÎÒ¶ÙʱɵÑÛÁË£¬Ôõô»¹ÒªÎÒÔÚ±¾µØ×°ÓÐOracleÂð£¿ÎÒÐÄÏëÓ¦¸Ã²»»áÓÐÕâÖÖÏÞÖÆÑ¾£¬ÓÐÄÇλ´óϺ¿ÉÒÔ¸æËßÎÒÔõô½â¾öÕâ¸öÎÊÌ⣿
лл¡£
±¾µØÒª×°Oracle Client
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
¿ÉÊÇ¡£ÎұȽÏÄÉÃÆµÄÊÇΪʲôJDBCÁ¬½ÓµÄʱºò²»ÐèÒªinstantclientÄØ£¿
ÄãÓ¦¸ÃÏȸãÒ»¸ãoracle×î»ù´¡µÄ¶«Î÷£¬±ÈÈçoracle net¡£
Èç¹û¾OCIÈ¥Á¬oracle serverµÄ£¬ÒªÓÃinstant client¡£¶øthin client¾Í²»ÐèÒª¡£ËùÒÔJDBC OCI Ò²ÒªÓÃinstant client¡£¶øJDBC thin drivers £¬¾Í²»ÐèÒª£¨Ó¦¸ÃÊÇͨ¹ýsocket£©
ÊÇÕâÑùµÄ£®¡¡ÄãµÃÔÚ±¾µØ°²×°cx_Oracle¡¡¿Í·þ¶Ë£®£®
ÎÒÃǹ«Ë¾·þÎñÆ÷ÉÏ×°µÄÊÇ£±£°£Ç¡¡¡¡£¬
ÎÒ±¾µØ×°µÄÊÇcx_Oracle-5.0.2-10g.win32-py2.5.msi£®
µ½¹ÙÍøÈ¥ÏÂÒ»¸ö°É£¬¡¡¶ÔÓ¦ÄãÒªÁ¬µÄ·þÎñÆ÷Oracle°æ±¾ÒÔ¼°Äã±¾»úPython°æ±¾£®
¶àл¸÷λ½â´ð£¬¿´À´¹é¸ù½áµ×»¹ÊÇOracleÌ«Èõ¡£
Ïà¹ØÎÊ´ð£º
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......