on 05-27-2022 09:27 AM - edited on 05-08-2024 07:59 AM by Tristan
Here are the steps to connect to an Oracle Cloud (Autonomous) Database.
Note: Whenever you upgrade Incorta, please copy these jar files again to the same location. These files will be removed during an upgrade.
JDBC URL example:
jdbc:oracle:thin:@incortadb_low?TNS_ADMIN=/Users/<user>/Downloads/Wallet_incortadb
You need to make sure to use the ojdbc from the same oracle version. For example, if the wallet files were from Oracle 18.3 and the target DB version is also 18.3 use the ojdbc8 jar from 18.3 version.
This link from Oracle should help you to understand the required steps.
This screenshot shows the compatibility matrix for the jdbc:
Additional steps that might be required to run the connection if it did not work:
ojdbc.properties
that is under the wallet folder as below:
oracle.net.wallet_location
javax.net.ssl
javax.net.ssl.trustStorePassword
and javax.net.ssl.keyStorePassword
without quotes (It's the password you specified when downloading the wallet from OCI Console or the Service Console)