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)" +
Ïà¹ØÎÊ´ð£º
ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡ ·¹ý£¬°ïÄ㶥һϡ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£ ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......
ÌâÄ¿£º ÓÐ1,2,3£¬4,5,6Áù¸öÊý×ÖÅÅÐò£¬ÓÃjava³ÌÐò¼ÆËã³öÅÅÐòµÄÖÖÀà¡£ ÒªÇó£ºÒ»£¬ÒÔ4¿ªÍ· ¶þ£¬2,3²»ÄÜÏàÁÚ Èý£¬²»ÄÜÒÔ5¿ªÍ· Ï£Íû´ó¼ÒÄܼ´ ......
ÓÐËÓÃjava×ö¹ý´òÓ¡·¢Æ±µÄ³ÌÐò£¬¸Ð¾õÕâ·½Ãæ²»ÊǺܺÿØÖÆ£¬Ï£Íû¸øµã½¨Ò飬×îºÃÄܸø³ö´úÂë ¼òµ¥µã¾Íµ÷ÓÃwindow.print() ÄãÒ²¿ÉÒÔ°ÑÏÂÃæ´úÂë·Åµ½ÄãJSPÖÐ: <html> <head> <title> ......
ÇëÎʸ÷λ¸ç¸ç½ã½ã£¬ÈçºÎÔËÓÃÏֳɵÄÄ£°åÀ´ÖÆ×÷ƯÁÁµÄJSPÍøÒ³Ñ½,»ØÕßÓзÖ! ×Ô¼º¶¥Ï£¬×ÜÓиßÊÖ°É,ÆÚ´ýÖÐ...... Èç¹ûÖ±½ÓÒýÓýøÈ¥ ¿ÉÒÔÖ±½ÓÓÃjspµÄÖ¸ÁҲ¿ÉÒÔÓÃfreemarkÒýÓ㬼ǵøø·Ö лл¸÷λÁË£¬¿´À´Î ......