Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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×Ö¶ÎÉèÖõÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ