Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

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

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

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


......

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

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

imp µ¼Èë oracle ÎÊÌâ

µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£

ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º

IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ