Discussions
Categories
- 382.6K All Categories
- 2.1K Data
- 213 Big Data Appliance
- 1.9K Data Science
- 448.5K Databases
- 221.1K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 541 MySQL Community Space
- 469 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 503 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.3K SQL & PL/SQL
- 21.1K SQL Developer
- 293.9K Development
- 9 Developer Projects
- 130 Programming Languages
- 290.6K Development Tools
- 97 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 151 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 146 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 201 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 299 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 168 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 235 Portuguese
Apache FOP behaving differently under Oracle 19
Hello,
We are using Apache FOP , stored within the database to be able to call a PLSQL routine that executes FOP and transforms XML to PDF format. This has been working successfully in our current live database using Oracle 12C for a number of years.
We are now in the process of migrating to Oracle 19C and have observed that our FOP process is behaving differently in that environment. Specifically, multi page PDF reports are not being rendered successfully , with blank pages being generated and only data appearing on the last page.
A specific XML payload to render a multi page PDF works successfully when processed through the same version of FOP outside of the database , but not when invoking FOP in the database via PLSQL.
On only 2 occasions we have been able to generate the specific report invoking FOP via PLSQL, which were after database/instance restarts , but then successive attempts resulted in the 'blank pages' situation, which has led me to think this could be some Java memory issue / leak. When we execute FOP via PLSQL it never errors or generates any diagnostics to suggest there is a problem.
Has anyone seen anything similar to this?
Thanks.
Best Answer
-
Hello again,
I have just found the solution to my problem, posting the details in case its of use for anyone else experiencing similar issues.
I changed the setting of the following system parameter - JAVA_JIT_ENABLED from its default setting of TRUE to FALSE and since then all FOP generated PDFs seem to be rendering successfully.
I'm not entirely sure why this has fixed the problem , and I only tried it as I was running out of ideas on what to do !
Answers
-
Hello again,
I have just found the solution to my problem, posting the details in case its of use for anyone else experiencing similar issues.
I changed the setting of the following system parameter - JAVA_JIT_ENABLED from its default setting of TRUE to FALSE and since then all FOP generated PDFs seem to be rendering successfully.
I'm not entirely sure why this has fixed the problem , and I only tried it as I was running out of ideas on what to do !