Çó½â MyEclipseÖÐÉèÖÃÁ¬½ÓOracle 10g³öÏÖµÄÎÊÌâ
ÈçÌâ¡£
¸ÕÔÚ×Ô¼ºµÄµçÄÔÀï°²×°ÀïOracle 10g
ÓÃMyEclipseÉèÖÃÁ¬½Ó£¬³öÏÖÈçÏ´íÎóÌáʾ£¬ÇëÎʸ÷λ¸ßÊÖÄÄÀï³öÁËÎÊÌ⣺¶àлָ½Ì£¡
Error while performing database login with the Oracle driver:
Io exception: The Network Adapter could not establish the connection
---------------------
ÔÚEclipseµÄDB BrowserÖÐ×öµÄÉèÖÃÈçÏ£º
Driver name £ºOracle
Connection URL : jdbc:oracle:thin:@localhost:1521:test
User name : scott
Password : tiger
Driver JARs: D:\lib\ojdbc14.jar
Driver classname: oracle.jdbc.driver.Oracle
¶àлָ½Ì£¡
lsnrctl start
ÕâÊÇʲô¶«¶«°¡£¬²»ºÃÒâ˼£¬°³Ð¡°×£¬ÇëÖ¸½Ì~
Microsoft Windows XP [°æ±¾ 5.1.2600]
(C) °æÈ¨ËùÓÐ 1985-2001 Microsoft Corp.
C:\Documents and Settings\user.HQ-TEXT>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-10ÔÂ-2009 17:4
3:58
Copyright (c) 1991, 2005, Oracle. All rights reserved.
TNS-01106: ʹÓÃÃû³ÆLISTENERµÄ¼àÌý³ÌÐòÒѾÆô¶¯
C:\Documents and Settings\user.HQ-TEXT>
Çý¶¯°ü²»ÊÇ*12.jarÂ𣿠ʲôʱºò±ä³É14ÁË...
Ïà¹ØÎÊ´ð£º
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼
Ö麣ÄDZßËÆºõûÉîÛÚºÃ.
Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
±ðÈ˸øÁËÎÒÔ¶³ÌoracleÊý¾Ý¿âµÄÐÅÏ¢£º¹Ì¶¨IP£¬¶Ë¿ÚºÅºÍSID£¬»¹ÓÐÓû§ÃûºÍÃÜÂ룬ËûµÄÊý¾Ý¿âÊÇoracle9i,ÎÒµÄÒ²ÊÇ£¬ÎÒÈçºÎ²ÅÄÜÁ¬½Óµ½ËûµÄÊý¾Ý¿âµÃµ½Êý¾Ý£¬Çë¸ßÊÖ°ïæָµãһϣ¬²»Ê¤¸Ðл£¡
ÎÊÌâûÓнâ¾ö
wildwave£¬ ......
ÏÂÃæÊǸոÕÖØÆôºóÔËÐÐnetstatµÄ½á¹û£¬ÕªÂ¼ÁËÆäÖÐÓë1521¶Ë¿ÚÓйصIJ¿·Ö
TCP tky-026e3e945e8:1055 localhost:1521 ESTABLISHED
TCP ......