ORACLE RAC 数据源配置

 

 
<Resource 
	type="javax.sql.DataSource" 
	auth="Container"
	driverClassName="oracle.jdbc.driver.OracleDriver" 
	url="jdbc:oracle:thin:@(DESCRIPTION_LIST = (LOAD_BALANCE = OFF) (FAILOVER = ON) 
			(DESCRIPTION =  (ADDRESS_LIST =   (LOAD_BALANCE=OFF)   (FAILOVER=ON)   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.90)(PORT = 1521))  )  (CONNECT_DATA =   (SERVICE_NAME = ORAINS)   (INSTANCE_NAME = ORAINS1)   (FAILOVER_MODE=(TYPE=SESSION)(METHOD=BASIC)(RETRIES=4)(DELAY=1))  ) ) 
			(DESCRIPTION =  (ADDRESS_LIST =   (LOAD_BALANCE=OFF)   (FAILOVER=ON)   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.91)(PORT = 1521))  )  (CONNECT_DATA =   (SERVICE_NAME = ORAINS)   (INSTANCE_NAME = ORAINS2)   (FAILOVER_MODE=(TYPE=SESSION)(METHOD=BASIC)(RETRIES=4)(DELAY=1))  ) )
			)" 
	name="jdbc/MYDB" 
	username="test" 
	password="test*123" 
	
	maxActive="40" 
	minIdle="1" 
	maxIdle="5" 
	initialSize="5" 
	
	    
	maxWait="60000"
	connectionProperties="oracle.net.CONNECT_TIMEOUT=10000"
	testOnBorrow="true"
	removeAbandoned="false" 
	validationQuery="select 1 from dual" 
	validationQueryTimeout="10"
/>

 

   当数据源启动时，连接第一个数据库实例，当第一个数据库实例失败时，自动切换到另一个实例 上。

 

connectionProperties="oracle.net.CONNECT_TIMEOUT=10000"

    jdbc 连接数据库超时时间设置，避免数据库实例不响应时，无限等待。