Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 439 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 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 !