1. Oracle服务器单机连接配置
1.使用service_name,
配置方式:jdbc:oracle:thin:@//<host>:1521/net_grid
2.使用SID,
配置方式:jdbc:oracle:thin:@//<host>:1521/netgrid
3.使用SID,
配置方式:jdbc:oracle:thin:@<host>:1521:netgrid
比较:
1和2中当@后边有双斜杠,端口号后边有单斜杠时,
用服务名和实例名都可以链接成功;
3中@后边没有双斜杠,端口号后边是冒号而不是斜杠的时候,
只能用实例名;
2. Oracle服务器集群配置参考:
url: jdbc:oracle:thin:@集群连接内容
spring:
profiles:
active: prod
datasource:
driver-class-name: oracle.jdbc.driver.OracleDriver
url: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=www.sanyuepao.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))
username: test
password: 123456
type: com.zaxxer.hikari.HikariDataSource
hikari:
minimum-idle: 10
maximum-pool-size: 50
auto-commit: true
idle-timeout: 60000
pool-name: DatebookHikariCP
max-lifetime: 120000
connection-timeout: 30000
connection-test-query: SELECT 1 FROM DUAL