pyreportjasper oracle

[khantechie]

from platform import python_version
from pyreportjasper import PyReportJasper
import os

def advanced_example_using_database():
REPORTS_DIR = "D:\Haroon_Docs\TAC-PROJECT\jasper"

input_file = os.path.join(REPORTS_DIR, 'csv.jasper')

data_source = [
 {"TPO_ID": "TPO_ID", "TPO_SUPP_NAME": "TPO_SUPP_NAME", "TPO_DATE": "TPO_DATE", "TPO_ATTN_TO": "TPO_ATTN_TO"
  , "TPO_SUPP_TEL": "TPO_SUPP_TEL", "TPO_SUPP_EMAIL": "TPO_SUPP_EMAIL"}
    ]



conn = {
'jdbc_driver': 'oracle.jdbc.driver.OracleDriver',
'jdbc_url': 'jdbc:oracle:thin:@10.100.10.16:1521/TACTESTPDB.TAC.LOC',
'jdbc_user': 'PARKING',
'jdbc_pass': 'PARKING123',
'jdbc_dir': 'E:\Ayoub Backup\E'
    }

output = os.path.join(REPORTS_DIR, 'csv')

print(python_version())
pyreportjasper = PyReportJasper()
pyreportjasper.config(
    input_file,
    output_file=output,
    output_formats=["pdf"],
    # parameters={'python_version': '3.7.4'},
    db_connection=conn,
    resource="E:\Ayoub Backup\E",
 locale='en_US')
pyreportjasper.process_report()

advanced_example_using_database()

error:
[0.010s][warning][cds] Archived non-system classes are disabled because the java.system.class.loader property is specified (value = "org.update4j.DynamicClassLoader"). To use archived non-system classes, this property must not be set
ERROR StatusLogger No log4j2 configuration file found. Using default configuration: logging only errors to the console. Set system property 'org.apache.logging.log4j.simplelog.StatusLogger.level' to TRACE to show Log4j2 internal initialization logging.
Traceback (most recent call last):
File "d:\Haroon_Docs\TAC-PROJECT\PARKING\PARKING_APP\jasper1.py", line 44, in
advanced_example_using_database()
File "d:\Haroon_Docs\TAC-PROJECT\PARKING\PARKING_APP\jasper1.py", line 41, in advanced_example_using_database
pyreportjasper.process_report()
File "D:\Haroon_Docs\TAC-PROJECT\PARKING\venv\Lib\site-packages\pyreportjasper-2.1.2-py3.11.egg\pyreportjasper\pyreportjasper.py", line 182, in process_report
raise error
NameError: Error fill report: It was not possible to add the path E:\Ayoub Backup\E to the Class Path: ERROR: java.io.IOException: Error, could not add URL to system classloader!