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·ÃÎÊ
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
Óиö´æ´¢¹ý³ÌÓÐÈý¸öInt²ÎÊýºÍÒ»¸öOut²ÎÊý.
Ö´ÐÐʱÏȽ«Ò»Ð©Êý¾Ý²åÈëµ½Ò»¸ö±íÖÐ.È»ºóÔÙ´Ó±íÖÐÈ¡³öÊý¾Ý½øÐÐÐÐתÁÐ,ºÏ¼ÆµÈÂß¼.½«´¦Àí½á¹û·Åµ½Ò»¸ö±íÖÐ.²¢½«Idͨ¹ýOut²ÎÊý·µ»Ø.
µ«ÔÚÖ´ÐÐʱ¿ÉÒÔ»ñÈ¡µ½OutÖµ,µ«¾ÍÊÇà ......