fop4apex

Servlet for Oracle APEX to run PDF Reports based on Apache FOP

Fahrdienst-Anwendung / Kostenblatt

• Uses Apache FOP for rendering https://xmlgraphics.apache.org/fop/
• Uses JavaMelody for monitoring https://github.com/javamelody/javamelody/wiki
• Use Java 11 LTS (also tested with Java 17 LTS and Java 21 LTS)

Run tests

mvn test

Build

mvn package verify

Upgrade

• set new version in pom.xml
• check dependent libraries for updates
• run tests and build

Release

• create a tag with version number
• create a github release

Installation

• rename target/fop4apex*.war to fop4apex.war
• copy fop4apex.war to tomcat webapps folder
• Oracle APEX - Sample Settings
  • PrintServer External (Apache FOP)
  • Protocol HTTP / HTTPS
  • Host 127.0.0.1
  • Port 8080
  • Script: /fop4apex/pdf
  • Timeout 300

Debugging

Add to Tomcat logging.properties:

org.apache.tomcat.util.http.Parameters.level = ALL
de.pdv.apex.level = ALL

Deploy to tomcat 9.x (IntelliJ / Netbeans) / Jetty 10.x

Run http://localhost:port/

Example:

• http://localhost:8080/fop4apex_war_exploded/
• http://localhost:8080/fop4apex_war_exploded/monitoring

Conversion using Apache fop (windows powershell)

$env:PATH="c:\Users\oliver1\Downloads\_tools\fop-2.9\fop;$env:PATH"
cd src\test\ressources\samples
fop.cmd  -xsl kostenblatt_2014.xsl    -xml kostenblatt_2014.xml    -pdf Result2014.pdf
fop.cmd  -xsl kostenblatt_2023_vh.xsl -xml kostenblatt_2023_vh.xml -pdf Result2023_vh.pdf
fop.cmd  -xsl kostenblatt_2023_e.xsl  -xml kostenblatt_2023_e.xml  -pdf Result2023_e.pdf
start Result.pdf