2010-05-13 10:29:35,499 [com.mchange.v2.resourcepool.BasicResourcePool] com.mcha
nge.v2.resourcepool.BasicResourcePool$AcquireTask@177fa9a -- Acquisition Attempt
Failed!!! Clearing pending acquires. While trying to acquire a needed new resou
rce, we failed to succeed more than the maximum ......
СµÜÎÒÕâѧÆÚÔÚѧOracle¡£°²×°ÁËOracle 10.2.0°æ±¾¡£µ«³öÏÖÁËÈçÏÂÎÊÌâ¡£
ORACLEÊý¾Ý¿âµÄORCLÊý¾Ý¿âÄÜͨ¹ýemÀ´¹ÜÀí£¬ÓÐoracleDBConsoleorcl·þÎñ¡£
È»ºóÎÒ×Ô¼ºÐ½¨ÁËÒ»¸öÊý¾Ý¿â¡£·¢ÏÖ·þÎñÀïʲô·þÎñ¶¼ÓУ¬¾ÍÊÇûÓÐoracleDBConsoleorcl·þÎñ¡£
ÓôÃÆËÀÁË¡£
»á²»»áÊǰ汾µÄÎÊÌâѽ¡£ÄѵÀÒªÖØ×°£¿ÅµÈÏÂ֨װ»á¸ü³öÎÊÌ⣬ʲô²ÐÓ ......
¿´ÏÂÃæsqlÓï¾ä£¬ÎÒÏëÓà rw À´ÊµÏÖ´Ón-mµÄ½ØÈ¡
select * from(select times,pages,rownum rw from layouts) where times='20090105' order by pages asc;
½á¹ûÊÇ£º
times pages rw
20090105 A001 96
20090105 A002 97
20090105 A003 98
.
.
Ϊʲôrw²»ÊÇ´Ó1¿ªÊ¼µÄ£¿ÒÔÖÁÓÚÎÒÔÚwhereºóÃæÓà r ......
ÏëÓÃoracleµÄDB Link Á¬½ÓAS400·þÎñÆ÷,°´ÕÕÍøÉÏËù˵ÓÃ͸Ã÷Íø¹Ø·½·¨,µ«ÊÇÔõô¶¼Á¬²»ÉÏAS400·þÎñÆ÷,
ÇóÆäËû·½·¨»ò³É¹¦°¸ÀýÏêϸÉèÖÃ~ллÀ²~
Á¬½Óas400 db2? db2ûÓùý£¬°ï¶¥
Çó½â~~~~~~
ûÓÐÈËÕâÑùÁ¬½Ó¹ýô?°æÖ÷°ïÎÒתµ½DB2¿´¿´°¡~~
{{ ......
ÎÒ´ÓÁíÍâһ̨»ú×ÓÉϵÄoracleÉϵ¼³öÁËÒ»¸öÓû§A£¬µÃµ½A.DMP£¬µ¼³öÊdzɹ¦µÄ¡£ È»ºó£¬ÔÚÎҵĻú×ÓÉϵ¼ÈëÁËoracleÖУ¬ÎÒÔÚÓû§BϽøÐеÄIMPµ¼È룬ÏÔʾ³É¹¦ÖÕÖ¹µ¼È룬ûÓгöÏÖ¾¯¸æ£¬¿ÉÎҵǼµ½BÒÔºó£¬È´Ã»Óз¢ÏÖÓÐÈκε¼ÈëµÄ¶«Î÷£¬ÓÃPL/SQLÒ²¿´²»¼û¡£Çë¸÷λ°ïæָ½Ìһϣ¬Èç¹û²é¿´µ¼ÈëµÄÓû§¡£¼±£¡
exp/imp Óï¾äÔõôдµÄ£¿¡ ......
ÈçºÎÈò»Í¬Óû§×éϵÄÓû§¿´µ½Ä³¸ö±íµÄ²»Í¬×ֶΣ¬ÒDZíÅÌÒѾ°ÑËùÓÐ×ֶζ¼ÏÔʾ³öÀ´ÁË£¬ÏÖÔÚÏëÈò»Í¬Óû§µÇ¼½øÈ¥¿´µ½µÄÄÚÈݲ»Ò»Ñù£¬±ÈÈçaÓû§Òª¿´±íµÄc1£¬c2£¬bÓû§Òª¿´Õâ¸ö±íµÄc4£¬c5£¬ÈçºÎÉèÖ㬼±Çó½â£¡
ÊÓͼ....
ÊÇÔÚbieeÀ²»ÊÇoracle°¡
......