Skip to Content
0
Dec 14, 2022 at 02:04 AM

I want to make a JDBC connection from Cloud Integration to Oracle DB.

772 Views Last edit Dec 14, 2022 at 06:11 AM 4 rev

Hello Expert.

I want to make a JDBC connection from Cloud Integration to Oracle DB.

Successfully connected to Oracle19 locally

I can't connect, Oracle versions 9i and 11g are on different servers

I am using the Driver downloaded from the following URL

https://download.oracle.com/otn-pub/otn_software/jdbc/1911/ojdbc8.jar

The error message is as follows

・9i

org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection, cause: java.net.ConnectException: error 111 - Connection refused

・11g

org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: ORA-00604: 再帰SQLレベル1でエラーが発生しました。 ORA-01882: タイムゾーンのリージョンが見つかりません , cause: java.sql.SQLException: ORA-00604: 再帰SQLレベル1でエラーが発生しました。 ORA-01882: タイムゾーンのリージョンが見つかりません

What I did

1. Install database on on-prem server

2. Installed CloudConnector on the same server as the database

3.Add settings to Cloud Connector to communicate via TCP/1521.

4.Added JDBC Driver in Cloud Integration monitor

5.Add Oracle connection setting in Cloud Integration monitor

6..Create iflow using connection settings of 5.

7.Test Iflow

Please advise.

regards.