ÓÐËÓùýOracle FCF
ÓÃJava JDBC Thinµ÷ÓÃORACLE FAST CONNECTION FAILOVERʱ£¬¸ÃÈçºÎÔÚ´úÂëÀïÖ¸¶¨×Ô¶¯ÖØÐÂCONNECT£¬µ±CONNECTION¶ªÊ§µÄʱºò¡£
ûÓùý£¬°ï¶¥
JDBC URL×Ö·û´®¼ÓÉÏautoReconnect=true
²»±£Ö¤ÓÐЧ£¬ÕâÖ»Êǹ淶£¬ÐèÒªÊý¾Ý¿âÖ§³Ö
Êý¾ÝÁ¬½Ó³ØÖ±½ÓÉèÖÃÀàËÆÊôÐÔautoReconnect=true
»ù±¾µÄ²ÎÊýÉèÖÿ϶¨ÓУ¬µ«Êµ¼ÊЧ¹ûÓëÔ¤ÆÚ²î±ð±È½Ï´ó£¬Ã»ÓÐÈË×ö¹ýÂð
·¹ý£¬²»ÖªµÀÄܲ»ÄÜÅ䣬¹Ù·½ÎĵµÔÚ´Ë£º
http://www.oracle86.com/ora_doc/java.111/b31224/fstconfo.htm
²Î¿¼²Î¿¼¹Ù·½Îĵµ
Æäʵ£¬ÎÒ¾ÍÊÇÓÃ2¸ö¶ÀÁ¢µÄDB£¬°Ñservice_name¸Ä³ÉÒ»Ñù£¬Ä£·ÂRAC
FCF ÊÇʲô£¿
ûÓùý£¬°ï¶¥
ÔÚcatchÀïÃære-connect¾Í¿ÉÒÔÁË¡£
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......