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.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?
2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£
ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º
IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......