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»Çø·Ö´óСдµÄ¡£ °ÑÄãµÄÁ¬¿âÓï¾äÌùÉÏÀ´¿
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£ ½á¹û±ÈÈ磺 3 30 4 50 ÎÒÏëµÃµ½Õâ¸ö½á¹û£º 1 0 2 0 3 30 4 50 5 0 Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл nobody ......