Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IO Error: could not resolve the connect identifier

Team KApr 14 2020 — edited Apr 15 2020

Hi guys,

I am trying to connect some Java code to ATP db via jdbc,

but above error pops as SQLException on connection.

Looking at the connection samples here https://github.com/oracle/oracle-db-examples/blob/master/java/jdbc/ConnectionSamples/DataSourceSample.java

here is my failing connection string:

ORACLE_REMOTE_URL = "jdbc:oracle:thin:@Wallet_db202004140937?TNS_ADMIN=E:/easyinc/Java/projects/08\\ multi\\ db\\ by\\ jdbc\\ driver/config/Oracle\\ Cloud";

This

ORACLE_REMOTE_URL = "jdbc:oracle:thin:@db202004140937_medium?TNS_ADMIN=E:/easyinc/Java/projects/08\\ multi\\ db\\ by\\ jdbc\\ driver/config/Oracle\\ Cloud";

also fails.

In terminal 'echo $TNS_ADMIN' correctly returns the directory where my wallet zip is extracted,

the ATP instance is up and ok, SQLDeveloper connection works fine.

Would appreciate some advice to fix my connection details.

Regards, K.

This post has been answered by Team K on Apr 15 2020

Jump to Answer

Added on Apr 14 2020

#general-questions, #jdbc

2 comments

4,689 views