Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Ok I sorted this one out. In file $SPARK_HOME/bin/conf/spark-defaults.conf Set the parameter *spark.driver.extraClassPath* to the additional jar files that you need --> ojdbc8.jar","oraclepki.jar","osdt_cert.jar","osdt_core.jar . spark.driver.extraClassPath

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Mich, That's right, referring to you guys. Cheers, Kuassi On 8/27/20 9:27 AM, Mich Talebzadeh wrote: Thanks Kuassi, I presume you mean Spark DEV team by "they are using ... " cheers, Mich LinkedIn /https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Thanks Kuassi, I presume you mean Spark DEV team by "they are using ... " cheers, Mich LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * *Disclaimer:* Use it at

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

According to our dev team. From the error it is evident that they are using a jdbc jar which does not support setting tns_admin in URL. They might have some old jar in class-path which is being used instead of 18.3 jar. You can ask them to use either full URL or tns alias format URL with

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

And this is a test using Oracle supplied JAVA script DataSourceSample.java with slight amendment for login/password and table. it connects ok hduser@rhes76: /home/hduser/dba/bin/ADW/src> javac -classpath ./ojdbc8.jar:. DataSourceSample.java hduser@rhes76: /home/hduser/dba/bin/ADW/src> java

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Hi Kuassi, This is the error. Only test running on local mode scala> val driverName = "oracle.jdbc.OracleDriver" driverName: String = oracle.jdbc.OracleDriver scala> var url = "jdbc:oracle:thin:@mydb_high ?TNS_ADMIN=/home/hduser/dba/bin/ADW/DBAccess" url: String = jdbc:oracle:thin:@mydb_high

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Fwiw here are our write-ups on Java connectivity to Database Cloud Services: https://www.oracle.com/database/technologies/appdev/jdbc-db-cloud.html Kuassi On 8/26/20 1:50 PM, Mich Talebzadeh wrote: Thanks Jorn, Only running in REPL in local mode This works fine connecting with ojdbc6.jar

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Thanks Jorn, Only running in REPL in local mode This works fine connecting with ojdbc6.jar to Oracle 12c. cheers LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw *

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Is the directory available on all nodes ? > Am 26.08.2020 um 22:08 schrieb kuassi.men...@oracle.com: > >  > Mich, > > All looks fine. > Perhaps some special chars in username or password? > >> it is recommended not to use such characters like '@', '.' in your password. > Best, Kuassi > On

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Mich, All looks fine. Perhaps some special chars in username or password? it is recommended not to use such characters like '@', '.' in your password. Best, Kuassi On 8/26/20 12:52 PM, Mich Talebzadeh wrote: Thanks Kuassi. This is the version of jar file that work OK with JDBC connection

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Thanks Kuassi. This is the version of jar file that work OK with JDBC connection via JAVA to ADW unzip -p ojdbc8.jar META-INF/MANIFEST.MF Manifest-Version: 1.0 Implementation-Title: JDBC *Implementation-Version: 18.3.0.0.0* sealed: true Specification-Vendor: Sun Microsystems Inc.

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Hi, From which release is the ojdbc8.jar from? 12c, 18c or 19c? I'd recommend ojdbc8.jar from the latest release. One more thing to pay attention to is the content of the ojdbc.properties file (part of the unzipped wallet) Make sure that ojdbc.properties file has been configured to use Oracle

Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

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