JDBC Á¬½Ó Oracle - Java / Java SE
ʹÓà JDBC Á¬½Ó Oracle ʱ£¬Èç¹û URL д³É£ºjdbc:oracle:thin:@192.168.1.100:1521:sid (192.168.1.100 ÊDZ¾»ú IP) ´ËʱÔÚ»ñÈ¡ Connection ʱ½«³öÏÖÒÔÏÂÒì³£¡£ Java code: java.sql.SQLException: The Network Adapter could not establish the connection µ«Èç¹û½« URL д³É jdbc:oracle:thin:@localhost:1521:sid £¨localhost Ò²¿ÉÒÔ»»³É 127.0.0.1£© ¾ÍûÓÐÎÊÌâ¡£ ÕâÑùµ¼ÖÂÎÒÎÞ·¨´ÓÁíÍâµÄ pc Á¬½Óµ±Ç°Õą̂ pc É쵀 oracle ÁË~~ Íû´Í½Ì~~
¹À¼ÆÊÇoracleȨÏÞÎÊÌ⣬ûÓпª·ÅÍâ½ç·ÃÎÊȨÏÞÒýÓà ¹À¼ÆÊÇoracleȨÏÞÎÊÌ⣬ûÓпª·ÅÍâ½ç·ÃÎÊȨÏÞ ÄÜ·ñ¸æËßÈçºÎ¿ªÆôÍâ½ç·ÃÎÊȨÏÞÄØ£¿ ¿ÉÒԵģ¡ oracle¹Ù·½ÍøÕ¾ÉÏÃæÕÒ¡£¾ßÌåÉèÖÃ×Ô¼ºÃþË÷°É£¡ For JDBC Thin: You must specify a full name-value pair connect string (the same as it might appear in the tnsnames.ora file) instead of the short JDBC Thin syntax. For example, instead of "jdbc:oracle:thin:@host:port:sid" you would need to use a string of the form "jdbc:oracle:thin:@(DESCRIPTION=" + "(ADDRESS_LIST=" + "(ADDRESS=(PROTOCOL=TCP)" + "(HOST=host)" +
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£ ´Ê¿âÔõôÉú³ÉÄØ£¿ ²»»á¡£ ÒýÓà ´Ê¿âÔõôÉú³ÉÄØ£¿ ÕÒ±¾×Öµä ÒýÓà ´Ê¿âÔõôÉú³ÉÄØ£¿ Êý¾Ý¿â ºÇºÇ ÓÃmap ¼üÖµ¶ÔÓ¦ Èç¹ûÓÃÊý¾Ý¿ ......
ÓÐËÓÃjava×ö¹ý´òÓ¡·¢Æ±µÄ³ÌÐò£¬¸Ð¾õÕâ·½Ãæ²»ÊǺܺÿØÖÆ£¬Ï£Íû¸øµã½¨Ò飬×îºÃÄܸø³ö´úÂë ¼òµ¥µã¾Íµ÷ÓÃwindow.print() ÄãÒ²¿ÉÒÔ°ÑÏÂÃæ´úÂë·Åµ½ÄãJSPÖÐ: <html> <head> <title> ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã ´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......