¡¾ÐÂÊÖÇë½Ì¡¿¿Í»§¶ËÁ¬½ÓoracleÊý¾Ý¿â
±¾»úÉϰ²×°ÁËoracle¿Í»§¶Ë,ÏëÁ¬½ÓÔ¶¶ËµÄoracleÊý¾Ý¿â,Ŀǰ
net·þÎñÃüÃû(test)ͨ¹ý²âÊÔ£¬
ÓÃsqlplus system/pass@testÒ²Á¬½ÓÉÏÁËÊý¾Ý¿â¡£
ÎÊÌâÊÇ£º
ÓÃodbcÅäÖÃʱ£¬Ñ¡ÓõÄÊÇoracle¿Í»§¶Ë×Ô´øµÄÇý¶¯³ÌÐò£¨oracle in OraClient10g_home1£©£¬µã»÷¡°test connection"ºó£¬³öÏÖµÄÅäÖýçÃæ£º·þÎñÃüÃûtest×Ô¶¯Ñ¡Ôñ£¬Óû§ÃûÃÜÂë¶¼²»»á´í£¬¿ÉÊÇʼÖÕ³öÀ´"Unable to connect SQLState=08004[oracle][odbc][Ora]Ora-12154:TNS:Could not resolve the connect identifier specified"
ÎÒµ½·þÎñÆ÷¶ËÓÃͬÑùµÄ·½·¨ÅäÖÃodbc£¬ÊÇÕýÈ·µÄ¡£
·þÎñÆ÷¶ËÓÐsymantec,ÄÜÍ£µÄ·þÎñ¶¼Í£ÁË£¬Ö»ÓÐÒ»¸ösymantec spbbcsvcÎÞ·¨Í£¡£
Çë½Ì¸÷λ¸ßÊÖ£¬ÕâÎÊÌâµ½µ×³öÔÚÄÄ£¿
ÄãÒѾͨ¹ý·þÎñÃû¿ÉÒÔÁ¬½ÓÊý¾Ý¿âÁË,²»ÐèÒªODBCÁË.
ͬÒ⣬ʹÓÃoracle²»ÐèÒªÅäÖÃodbc
LS¶þ룬ÎÒ×îÖÕÄ¿µÄÊÇÔÚc#ÖнøÐÐÊý¾ÝÁ¬½Ó¡£¿ÉÊÇÎÒÁ¬²»ÉÏ¡£
C#Ã²ËÆÖ»Òª¿Í»§¶ËÄÜÁ¬£¬Ö±½ÓʹÓÃNETÅäÖõÄÄǸö·þÎñÃû¾Í¿ÉÒÔ°¡¡£±ÈÈç¾ÍÓÃÄãÕâÀïµÄtestÓ¦¸ÃÊÇûÎÊÌâµÄ¡£
¿ÉÄÜÎÊÌ⻹ÊdzöÔÚC#
Ö§³ÖÒ»ÏÂ~
c#µÄÊý¾ÝÁ¬½Ó£º
£¨1£©Êý¾ÝԴѡȡ¡±oracleÊý¾Ý¿â¡°£¬ÅԱߵÄ˵Ã÷¡±ÊÇÁ¬½Ó9iÒÔϵÄÊý¾Ý¿â¡°£¬ÎÒËùÁ¬µÄÊý¾Ý¿âÊÇ10g,»¹ÊÇÊÂÁË£¬×îÖÕÏÔʾ¡°Ora-12154:TNS:Could not resolve the connect identifier specified¡±
£¨2£©Êý¾ÝԴѡȡÆäËû¼¸¸ö¶¼²»ÐУ¬
ËùÒÔ°ÑÏ£Íû¼ÄÍÐÔÚodbcÉ
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
´ó¼ÒÓöµ½ORACLE·ÖÒ³¶¼ÊÇÔõô´¦ÀíµÄ£¿
ÊÇÓÃSQLÓï¾ä·ÖÒ³£¿»¹ÊÇÓÿɹö¶¯µÄ½á¹û¼¯·ÖÒ³£¿
Ï£Íû´ó¼ÒÄܰѴúÂëÌù³öÀ´¡£
×îºó´ó¼Ò¸Ð¾õÄÄÖÖЧÂʸߣ¿ÎªÊ²Ã´£¿
ÒªÊÇÓÃhibernateµÄ»°£¬¾Í²»ÓùÜÊDz»ÊÇoracleÁË¡£
ÎÒÖ»ÖªµÀorac ......