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Ì«Èõ¡£
Ïà¹ØÎÊ´ð£º
±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......
ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿
2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿©
ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ
£¿
¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡
Ò»°ã ......
Developer SuiteÁ¬½ÓÊý¾Ý¿âµÄÎÊÌ⣬ÀͼݸßÊÖÖ¸µã£¡
µçÄÔÀïÃæÍ¬Ê±×°ÁËOraHome92ºÍDevSuiteHome2£¬Ç°ÕßµÄsql*plusÄÜ·ÃÎÊ£¬ºóÕßµÄÔò²»ÐС£ÊäÈëscott/tigerµÇ½ºóÕßʱ£¬ÎÒÊäÈëÁË"Ö÷»ú×Ö·û´®"ºÅÒԺ󣬱¨´í£º&n ......