eclipseÖÐÁ¬½ÓoracleµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨ ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off client connection The Connection descriptor used by the client was: localhost:1521:orcl ) ¿ÉÊÇͨ¹ýpl/sqlµÈ¹¤¾ß²Ù×÷Êý¾Ý¿âûÓÐÎÊÌâ¡£ÖØ×°Êý¾Ý¿â»¹ÊDz»ÐУ¬»»eclipseÒ²²»ÐУ¬¶¼ÊÇÕâ¸öÎÊÌâ
¿´ÉÏÈ¥¾ÍÊÇÏîÄ¿ÀïÅäÖÃÎļþд´íÁË¡£¡£ ¿´¿´ÅäÖÃÎļþ°É ÎÒËùÓÐÁ¬½ÓoracleµÄÏîÄ¿¶¼³öÁËÕâ¸öÎÊÌ⣬²»ÊÇÒ»¸ö¹¤³Ì£¬¶øÇÒ֮ǰ¶¼ÊÇ¿ÉÓõġ£ ʹÓñðµÄÊý¾Ý¿âµÄÏîĿҲûÓÐÎÊÌ⣬Á¬½Óµ½·Ç±¾µØ¿âÒ²²»»á³öÕâ¸öÎÊÌâ¡£ localhost:1521:orcl ¸ÄΪ 127.0.0.1:1521:ORCL ÊÔÊÔ¿´£¿ ÁíÍâÊÇ·ñÄãµÄ±¾µØÃ»ÓÐORCLÕâ¸öSID°¡ÒýÓà localhost:1521:orcl ¸ÄΪ 127.0.0.1:1521:ORCL ÊÔÊÔ¿´£¿ ÎÒÊÔÁ˲»ºÃʹ£¬ÎÒÓÃPL/SQL devÊÇ¿ÉÒÔ´ò¿ª±¾µØµÄÕâ¸ösid ¶øÇÒ²»Ö»ÊÇÕâ¸ösid£¬±¾µØµÄÆäËüµÄÒ²²»ÐС£ ÏÖÔÚ¾ÍÊǹ¤³Ì²»ÄÜÁª½ÓOracleÊý¾Ý¿â£¬Ö®Ç°¶¼ÊÇ¿ÉÒÔÓõŤ³ÌÒýÓà ÎÒÊÔÁ˲»ºÃʹ£¬ÎÒÓÃPL/SQL devÊÇ¿ÉÒÔ´ò¿ª±¾µØµÄÕâ¸ösid ¶øÇÒ²»Ö»ÊÇÕâ¸ösid£¬±¾µØµÄÆäËüµÄÒ²²»ÐС£ ÏÖÔÚ¾ÍÊǹ¤³Ì²»ÄÜÁª½ÓOracleÊý¾Ý¿â£¬Ö®Ç°¶¼ÊÇ¿ÉÒÔÓõŤ³Ì °Ñ±¾µØµÄ·À»ðǽ¹ØÁËÊÔÊÔ¿´¡£ ÁíÍâ£¬ÖØÐÂÅäÖÃһϷþÎñÃû¡£ ¿´Êý¾Ý¿âµÄ¼àÌýÊÇ·ñ´ò¿ª¡£ ÁíÍâºÃÏñͨ¹ýeclipseÁ¬½ÓµÄsidÃû³ÆÊDz»Çø·Ö´óСдµÄ¡£ °ÑÄãµÄÁ¬¿âÓï¾äÌùÉÏÀ´¿
Ïà¹ØÎÊ´ð£º
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿ Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É SQL> select name from v$database; NAME --------- ORCL
......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......