Hi, The connection from Spark to Oracle 12c etc are well established using ojdb6.jar.
I am attempting to connect to Oracle Autonomous Data warehouse (ADW) version *Oracle Database 19c Enterprise Edition Release 19.0.0.0.0* Oracle document suggest using ojdbc8.jar to connect to the database with the following URL format using Oracle Wallet "jdbc:oracle:thin:@mydb_high?TNS_ADMIN=/home/hduser/dba/bin/ADW/DBAccess" This works fine through JAVA itself but throws an error with Spark version 2.4.3. The connection string is defined as follows val url = "jdbc:oracle:thin:@mydb_high ?TNS_ADMIN=/home/hduser/dba/bin/ADW/DBAccess" where DBAcess directory is the unzipped wallet for Wallet_mydb.zip as created by ADW connection. The thing is that this works through normal connection via java code.using the same URL So the question is whether there is a dependency in Spark JDBC connection to the ojdbc. The error I am getting is: java.sql.SQLRecoverableException: IO Error: Invalid connection string format, a valid format is: "host:port:sid" at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528) at java.sql.DriverManager.getConnection(DriverManager.java:664) This Oracle doc <https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-jdbc-thin-wallet.html#GUID-5ED3C08C-1A84-4E5A-B07A-A5114951AA9E> explains the connectivity. The unzipped wallet has the followiing files ls DBAccess/ README cwallet.sso ewallet.p12 keystore.jks ojdbc.properties sqlnet.ora tnsnames.ora truststore.jks Thanks Mich LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* *Disclaimer:* Use it at your own risk. Any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on this email's technical content is explicitly disclaimed. The author will in no case be liable for any monetary damages arising from such loss, damage or destruction.