Python/JDBC to Oracle Connection on Microsoft Windows Server Consultant

EXECUTIVE SUMMARY

Help us solve a Java class not found error with our Python/Jython script on Windows Server.

BACKGROUND

We have a Python/Jython script that is connecting to an Oracle database using JayDeBeAPI. For some reason, this script which was working fine before is now giving a JAVA class not found error.

We are looking for help debugging this in tandem.

Here is the error we are seeing:

Traceback (most recent call last):
File C:\\Users\\MTG4\\Documents\\Github\\mi2launch\\download.py, line 1067, in
chief(function, params)
File C:\\Users\\MTG4\\Documents\\Github\\mi2launch\\download.py, line 569, in chief
download_via_params(params)#
File C:\\Users\\MTG4\\Documents\\Github\\mi2launch\\download.py, line 1011, in download_via_params
column_list = cerner.get_table_columns(params[cerner_table_name]) # .insert(0,PERSON_ID)
File C:\\Users\\MTG4\\Documents\\Github\\mi2launch\\cerner.py, line 557, in get_table_columns
cur = connect_to_database()
File C:\\Users\\MTG4\\Documents\\Github\\mi2launch\\cerner.py, line 548, in connect_to_database
conn = jaydebeapi.connect(oracle.jdbc.driver.OracleDriver,jdbc:oracle:thin:MHGR_RO/readonly@//170.71.81.24/cust_p41.world)
File C:\\jython2.7.0\\Lib\\site-packages\\jaydebeapi-1.1.1-py2.7.egg\\jaydebeapi\\__init__.py, line 381, in connect
jconn = _jdbc_connect(jclassname, url, driver_args, jars, libs)
File C:\\jython2.7.0\\Lib\\site-packages\\jaydebeapi-1.1.1-py2.7.egg\\jaydebeapi\\__init__.py, line 110, in _jdbc_connect_jython
Class.forName(jclassname).newInstance()
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)

java.lang.ClassNotFoundException: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
About the recuiter
Member since Mar 14, 2020
Ahmed Khan
from Rhone-Alpes, France

---

---

Offer to work on this project closes in 18 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions