Forum Discussion
Fabric notebook - Oracle connection error: java.lang.ClassNotFoundException
I tested the code using the suggested syntax:
%load_new_custom_jar {mssparkutils.nbResPath}/builtin/ojdbc11.jar
However the error persists.
Py4JJavaError: An error occurred while calling o4395.load.
: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
I suppose this could be related to JDBC, JDK and Oracle interop versions.
I'm trying to access an Oracle 11.2.0.4 database, but the JDK defined in Fabric is JDK 11:
openjdk version "11.0.22" 2024-01-16 LTS
OpenJDK Runtime Environment Microsoft-8909545 (build 11.0.22+7-LTS)
OpenJDK 64-Bit Server VM Microsoft-8909545 (build 11.0.22+7-LTS, mixed mode, sharing)
It seems that to access Oracle DB 11.2, the correct JDK to use is not JDK11, but JDK 6, 7 or 8, according to the Oracle website:
Is there a way to downgrade Fabric JDK11 to JDK8, for example?
Thanks!
Hello Rodrivieiras ,
At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.
Hi, all right.
Hi Rodrivieiras ,
We got an information from internal team that we cannot downgrade the JDK version.Hello Rodrivieiras ,
We haven’t heard from you on the last response and was just checking back to see if we answered your query.
Otherwise, will respond back with the more details and we will try to help.