据我所知,故障转移配置依赖于jdbc驱动程序。如果是Oracle,则使用连接描述符对其进行配置。所以在你的情况下你会把这个放进去
tnsnames.ora
以下内容:
CONNECTION_WITH_FAILOVER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = primary.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = secondary.com)(PORT = 1521))
(LOAD_BALANCE = no)
(FAILOVER = yes)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = db)
(FAILOVER_MODE =
(TYPE = select)
(METHOD = preconnect)
(RETRIES = 180)
(DELAY = 10)
)
)
)
然后在您的配置中:
spring.datasource.url=jdbc:oracle:thin:@CONNECTION_WITH_FAILOVER
当然,您可能没有或不想使用
特恩斯纳姆斯·奥拉
,在这种情况下,可以将连接描述符用作JDBC连接字符串的一部分:
spring.datasource.url=jdbc:oracle:thin:&