Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......

Oracle Æô¶¯µÄÎÊÌâ

oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html

Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..

cm ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

½èˮԴÈËÆø£¡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ºÅ