Hello,
I am having issues to connect with the Oracle Cloud ATP Database 19c with jDeveloper 12.2.1.4.
Referring to the article in this forum https://community.oracle.com/tech/developers/discussion/4271196/failure-while-db-connection-to-atp-cloud-wallet-from-jdeveloper-12-2-1-3, I have set the JDBC custom connection URL, JDBC parameters, add the corresponding JDBC driver including ucp and other required files to the classpath of Model folder, enable Oracle PKI provider according another article https://blogs.oracle.com/dev2dev/ssl-connection-to-oracle-db-using-jdbc,-tlsv12,-jks-or-oracle-wallets. Somehow, I still get a IO error indicating the connection cannot be established. Please give me some suggestions.
Creating new Oracle JDBC driver library
Add newly generated JDBC driver library to Model Classpath
Custom JDBC connection URL
JDBC parameters
Some blogs mention about the incompatibility of Oracle Cloud database 12c 12.2.1.3 and above with jdeveloper. If it is the case, please suggest the right version of Oracle Cloud database. It is very confusing that the connection between Oracle Cloud ATP Database and SQL Developer is quite smooth with wallet connection, while the TCPS connection between ATP DB and jDeveloper is problematic.
Many thanks!
System settings:
JDK 8U271
JRE 8U271
Oracle ATP database 19c
JDBC driver ojdbc8/ucp/osdt_cert/osdt_core/oraclepi
jdeveloper 12c 12.2.1.4