Jasper Ideas

Fix the ORA-01795 error shown in JasperReports Server logs

We're using an Oracle database and are regularly seeing the ORA-01795 error shown in JasperReports Server logs.
The error is produced by a delete statement from the JIAccessEvent table, using the IN operator with an extremely long list of variables.
Oracle has a limitation of 1000 bind variables per statement.

I believe this is a bug, but the TIBCO support rep that landed my case believes otherwise. Since this is a documented fact, I believe it is up to TIBCO to generate valid SQL for every database they support, not up to Oracle to support unlimited number of bind variables.

I believe everyone that runs on Oracle would benefit from this "enhancement".

  • Guest
  • Dec 18 2023
  • To be Reviewed
Components JasperReports Server
  • Attach files