部门报错截图如下
[main] [com.zaxxer.hikari.pool.HikariPool]-[DEBUG] HikariPool-1 - Cannot acquire connection from data source
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:774)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)
分析发现applcation.yml的oracle配置项有误
spring:
datasource:
driver-class-name: oracle.jdbc.OracleDriver
username: system
password: system
url: jdbc:oracle:thin:@IP:1521:orcl
IP换成oracle的服务IP,后面的orcl要配置成服务名称
像楼主这种情况,url正确配置
jdbc:oracle:thin:@你的服务IP:1521:helowin
问题解决 可以正常操作orale数据库