Connection to Oracle databases

[JBAltidor]

Connections to oracle databases keeps throwing errors : • NameError: Error fill report: Erro fill internal: java.lang.NullPointerException • NameError: Error fill report: Java package 'net' is not valid The second I can't get around.

[jadsonbr]

Could you send us the full log?

[JBAltidor]

Traceback (most recent call last): File "c:*\cons_oracle.py", line 39, in oracle_database() File "c:*\cons_oracle.py", line 32, in oracle_database pyreportjasper.process_report() File "C:***\pyreportjasper.py", line 182, in process_report raise error NameError: Error fill report: Java package 'net' is not valid

---

Connection dictionnary conn = { 'driver': 'oracle', 'username': 'user', 'password': ****, 'host': ****, 'schema': *****, 'port': ***', 'jdbc_driver' : "oracle.jdbc.driver.OracleDriver", 'jdbc_dir': 'ojdbc8.jar' }

[jadsonbr]

try like this

Uninstall pyreportjasper

and install with

pip3 install git+https://github.com/acesseonline/pyreportjasper.git

and

  conn = {
    'driver': 'oracle',
    'username': '****',
    'password': '****',
    'db_sid': '****',
    'host': ****,
    'port': ****',
    'jdbc_driver' : "oracle.jdbc.driver.OracleDriver",
    'jdbc_dir': "C:\drivers\", # Inform the folder containing the jar file
  }
   pyreportjasper = PyReportJasper()
   pyreportjasper.config(
      input_file,
      output_file,
      output_formats=["pdf"],
      db_connection=conn,
      resource="C:\drivers"
   )
   pyreportjasper.process_report()

[JBAltidor]

Tried it, got that error : NameError: Error fill report: It was not possible to add the path C:/Users/**/Drivers to the Class Path: ERROR: java.io.IOException: Error, could not add URL to system classloader!

[jadsonbr]

To help, provide more details. If possible provide the code snippet you are running and attach the jdbc .jar file

Describe A clear and concise description.

To Reproduce Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: [e.g. Linux]
• Python version [e.g. 3.8]
• Library version [e.g. 2.1.0]
• Java version [e.g. 15]
• JVM [e.g. Oracle]

Jaspersoft Studio (please complete the following information):

• Version [e.g. 6.16.0]

Additional context Add any other context about the problem here.

[Nenadst023]

Hi,

I have same problem. My code..

import os
from pyreportjasper import PyReportJasper

os.environ["JAVA_HOME"] ="jvm/jdk-19.0.2/"

def advanced_example_using_database():
   REPORTS_DIR = os.path.join(os.path.abspath(os.path.dirname(__file__)), 'jrxml')
   input_file = os.path.join(REPORTS_DIR, 'stampaCenaA4.jrxml')
   output_file = os.path.join(REPORTS_DIR, 'stampaCenaA4')

   conn = {
     'driver': 'oracle',
     'username': '***',
     'password': '***',
     'host': '***',
     'port': '1521',
     'db_sid': '***',
     'jdbc_dir': 'x:\\nenad_ws\\-- PY RAZVOJ\\StampaCena\\oracle\\',
     'jdbc_driver': 'oracle.jdbc.driver.OracleDriver'
   }
   
   pyreportjasper = PyReportJasper()
   pyreportjasper.config(
     input_file,
     output_file,
     db_connection=conn,
     output_formats=["pdf"],
     parameters={'poj': '114', 'pbarkod':'8600043003444,8605006902987,7622210702593,9012200872739,3080216031811'},
     resource="x:\\nenad_ws\\-- PY RAZVOJ\\StampaCena\\oracle",
     locale='en_US'
   )
   pyreportjasper.process_report()
   
advanced_example_using_database()

Output: NameError: Error fill report: It was not possible to add the path x:\nenad_ws-- PY RAZVOJ\StampaCena\oracle\ to the Class Path: ERROR: java.io.IOException: Error, could not add URL to system classloader!

Project path..

Python ver: 3.10.7 Lib installed with pip3 install git+https://github.com/acesseonline/pyreportjasper.git - Version: 2.1.2 Java: open jdk-19.0.2 Jvm: Oracle OS: windows 11

Jaspersoft Studio: 6.20.0

[JBAltidor]

I still don't know how to make this thing work. But, I had a deadline so I worked aroud it by calling a bit of python code inside Java (as it woked perfectly with python). Don't know if that helps.

[gph]

I still don't know how to make this thing work. But, I had a deadline so I worked aroud it by calling a bit of python code inside Java (as it woked perfectly with python). Don't know if that helps.

Would you mind sharing your implementation?

Best Regards! Henry Gamba