jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = X.X.X.X)(PORT = 1526))(ADDRESS = (PROTOCOL = TCP)(HOST=X.X.X.X)(PORT = 1526))(LOAD_BALANCE= YES)(FAILOVER = ON))(CONNECT_DATA=(SERVER = DEDICATED)(SERVICE_NAME = ORCL)(FAILOVER_MODE =(TYPE =SELECT )(METHOD = BASIC)(RETRIES = 3)(DELAY = 5))))
HOST、PORT、SERVICE_NAME就不多解释了。
LOAD_BALANCE 表示负载均衡,合法值yes/no;
FAILOVER 表示故障转移,合法值on/off,默认是on;详见:
http://www.cnblogs.com/einyboy/archive/2012/11/19/2777855.htmlMETHOD = BASIC表示初始连接就连接一个接点,他还有个选项是preconnect,表示初始连接所有的接点。RETRIES:重试次数。DELAY:重试的延迟(以秒为单位)。
在上述链接中有详细描述。
posted on 2013-06-04 15:10
身在半空 阅读(3726)
评论(0) 编辑 收藏