java.sql.SQLRecoverableException: IO 오류: The Network Adapter could not establish the connection

2021. 8. 1. 19:10

오류 내용

java.sql.SQLRecoverableException: 
IO 오류: The Network Adapter could not establish the connection
(CONNECTION_ID=Lhy6mizPQI6NlC4VyObGMA==)

 

console.log

[http-nio-9090-exec-7] 
	[34mINFO [0;39m [36mcom.zaxxer.hikari.HikariDataSource
    [0;39m - HikariPool-2 - Starting... http-nio-9090-exec-7 [http-nio-9090-exec-7] 
    [1;31mERROR[0;39m 
    [36mcom.zaxxer.hikari.pool.HikariPool[0;39m - HikariPool-2 -
    Exception during pool initialization. http-nio-9090-exec-7 
    java.sql.SQLRecoverableException: 
    IO 오류: The Network Adapter could not establish the connection
    (CONNECTION_ID=Lhy6mizPQI6NlC4VyObGMA==) 
    at oracle.jdbc.driver.T4CConnection.handleLogonNetException(T4CConnection.java:870) 
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:675) 
    at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1032) 
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:90) 
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:681) 
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:602) 
    at net.sf.log4jdbc.sql.jdbcapi.DriverSpy.connect(DriverSpy.java:401) 
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSou

 

문제 부분

- application.yml 

여러 가지를 해봤는데 되지 않았는데
spring: 
	datasource: 
    	driver-class-name: net.sf.log4jdbc.sql.jdbcapi.DriverSpy 
        url: jdbc:log4jdbc:oracle:thin:@[ ip 주소]:[오라클 SID] 
username: [사용자 이름] 
password: [비밀번호] 
이 상태였다.

 

해결

- 아이피로 되어있던 부분을 localhost로 바꾸니 해결되었다.
spring: 
	datasource: 
    	driver-class-name: net.sf.log4jdbc.sql.jdbcapi.DriverSpy 
        url: jdbc:log4jdbc:oracle:thin:@localhost:[오라클 SID] 
username: [사용자 이름] 
password: [비밀번호]