<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 连接数据库超时时间设置,避免数据库实例不响应时,无限等待。