Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

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

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

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

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

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

Âé·³¸ø¿´¿´Õâ¸öoracleÓï¾ä¸ÃÔõÑùд

±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ