Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

jboss+oracleÅäÖÃÎÊÌâ

ÇëÎÊϱ¾µØÁ¬½ÓÔ¶³ÌoracleÊý¾Ý¿âʱÊÇ·ñÒ»¶¨Òª°²×°oracle¿Í»§¶Ë²ÅÐУ¿
oracleÁ¬½ÓʹÓãºjdbc:oracle:thin£¬ÔÚÍøÉÏ¿´µ½ËµÊ¹ÓÃthinÀ´Á¬½Ó¿ÉÒÔ²»Óð²×°oracle¿Í»§¶Ë£¬µ«ÊÇÎÒ°Ñ·þÎñ²¿Êðµ½jbossºó£¬³öÏÖÏÂÃæµÄÒì³££º
Java code:

01:02:09,703 ERROR [STDERR] Caused by: java.sql.SQLException: Io Òì³£: The Network Adapter could not establish the connection



ÆÚ´ý¸ßÊÖÏàÖú£¡£¡£¡
Ò¹ÉîÈ˾²£¬¶¼Ë¯¾õÁË£¿£¿

ѧϰ


ÒýÓÃ
²»Óñ¾µØ°²×°£¬ÄãµÄÎÊÌâÊÇÍøÂçÊÊÅäÆ÷²»Äܽ¨Á¢Á¬½Ó

¶¥

ÒýÓÃ
²»Óñ¾µØ°²×°£¬ÄãµÄÎÊÌâÊÇÍøÂçÊÊÅäÆ÷²»Äܽ¨Á¢Á¬½Ó

Äܸø³ö½â¾ö˼·Âð£¿Ð»Ð»


лл¸÷룬²»ÊÇÎÒ±¾µØ»·¾³µÄÎÊÌ⣬ÊÇÒòΪԶ³Ì·þÎñÆ÷ÐèVPN·ÃÎÊ


Ïà¹ØÎÊ´ð£º

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

php Öвéѯoracle date ÀàÐÍÊý¾ÝµÄÎÊÌâ?

ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

ADO.NETµ÷ÓÃOracle´æ´¢¹ý³Ì?

Óиö´æ´¢¹ý³ÌÓÐÈý¸öInt²ÎÊýºÍÒ»¸öOut²ÎÊý.
Ö´ÐÐʱÏȽ«Ò»Ð©Êý¾Ý²åÈëµ½Ò»¸ö±íÖÐ.È»ºóÔÙ´Ó±íÖÐÈ¡³öÊý¾Ý½øÐÐÐÐתÁÐ,ºÏ¼ÆµÈÂß¼­.½«´¦Àí½á¹û·Åµ½Ò»¸ö±íÖÐ.²¢½«Idͨ¹ýOut²ÎÊý·µ»Ø.
µ«ÔÚÖ´ÐÐʱ¿ÉÒÔ»ñÈ¡µ½OutÖµ,µ«¾ÍÊÇà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ