Spring Boot：Oracle RAC DB连接配置

Question

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL={PROTOCOL})(HOST={{URL})(PORT={PORT})))(CONNECT_DATA=(SERVICE_NAME={SERVICE_NAME})))

提前感谢您的帮助！

Answer 1

试试下面。

jdbc:oracle:thin:@(DESCRIPTION=
    @    (LOAD_BALANCE=on)
    @    (ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))
    @    (ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521))
    @    (CONNECT_DATA=(SERVICE_NAME=service_name)))

或

# Oracle settings
spring.datasource.url=jdbc:oracle:thin:@localhost:1522:orcl
spring.datasource.username=HIBERNATE_TEST
spring.datasource.password=HIBERNATE_TEST
spring.datasource.driver.class=oracle.jdbc.driver.OracleDriver

或

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=tst-db1.myco.com)(PORT=1604))
(ADDRESS=(PROTOCOL=TCP)(HOST=tst-db2.myco.com)(PORT=1604)))
(CONNECT_DATA=(SERVICE_NAME=mydb1.myco.com)(SERVER=DEDICATED)))