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 recuiterMember since Mar 14, 2020 Ahmed Khan
from Rhone-Alpes, France