문제 상황
MySQL에서 Oracle로 변경하는 중에 발생한 에러.
에러 코드
java.sql.SQLRecoverableException: IO 오류: Invalid number format for port number at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:553) at oracle.jdbc.driver.T4CConnection. (T4CConnection.java:254) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528) .... Caused by: oracle.net.ns.NetException: Invalid number format for port number at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:187) at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:133) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:431) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:693) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:251) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340) ... 83 more
해결 방안
텍스트 하나를 잘못 적어서 수정.
database.driver=oracle.jdbc.driver.OracleDriver
database.url=jdbc:oracle:thin:@//127.0.0.0:1521:testdb
를 아래로 수정.
잘 보면 포트 번호 뒤에 " : "가 " / "으로 변경되어 있음. 저 값 바꾸니 정상 동작했다.
database.driver=oracle.jdbc.driver.OracleDriver
database.url=jdbc:oracle:thin:@//127.0.0.0:1521/testdb
[Oracle] 다른 DB에 있는 테이블 값 쓰기 (DB Link) (0) | 2013.11.14 |
---|---|
[Oracle] Error setting null for parameter #4 with JdbcType OTHER (0) | 2013.11.14 |
[Oracle][ORA-01017] invalid username password logon denied (0) | 2013.11.12 |
[Oracle] 오라클 명령어 간단 정리 (0) | 2013.11.12 |
[Oracle] ORA-12514, TNS:listener does not currently know of service requested in connect descriptor (0) | 2013.11.12 |
댓글 영역