rohitit3031 Posted October 11, 2018 Share Posted October 11, 2018 Hi Folks , I am using Jaspersoft Studio 6.6.0 to create report. I have created a report and I am calling it in ADF application using below code :public static void main(String[] args) throws JRException, SQLException { JasperCall jasperCall = new JasperCall(); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@dbdetails", "username", "pass"); String file = "C://Users/test/JaspersoftWorkspace/MyReports/Test_Blank_report.jasper"; Map parameters = new HashMap(); parameters.put("testparam", "Test Parameter passed from adf"); System.out.println("--+"+ parameters+"---"+ con); JasperPrint jasperPrint = JasperFillManager.fillReport(report, parameters, con); File outDir = new File("D:/jasperoutput_generate"); outDir.mkdirs(); // PDF Exportor. JRPdfExporter exporter = new JRPdfExporter(); ExporterInput exporterInput = new SimpleExporterInput(jasperPrint); // ExporterInput exporter.setExporterInput(exporterInput); // ExporterOutput OutputStreamExporterOutput exporterOutput = new SimpleOutputStreamExporterOutput("D:/jasperoutput_generate/FirstJasperReport.pdf"); // Output exporter.setExporterOutput(exporterOutput); SimplePdfExporterConfiguration configuration = new SimplePdfExporterConfiguration(); exporter.setConfiguration(configuration); exporter.exportReport(); System.out.print("Done!"); }[/code] My Report jrxml code is given below :<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.6.0.final using JasperReports Library version 6.6.0 --><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Test_Blank_report" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="0eea1e31-19b2-477b-ac75-0cbea1863a5a"> <property name="com.jaspersoft.studio.data.sql.tables"> <![CDATA[ilRXX1ZFU1NFTCIgQVMgLDg1LDEwMCw5NDIzYmU0Ni03OGRiLTQ3ZTUtYjNjNy1mOWFiNmRhN2E3MTY7]]> </property> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="VesselConn_Test"/> <parameter name="testparam" class="java.lang.String"/> <queryString language="SQL"> <![CDATA[sELECT "TW_VESSEL"."VESSEL_ID", "TW_VESSEL"."VESSEL_IMO_NO", "TW_VESSEL"."VESSEL_CODE", "TW_VESSEL"."VESSEL_NAME", "TW_VESSEL"."VESSEL_TYPE", "TW_VESSEL"."VESSEL_OPERATOR", "TW_VESSEL"."VESSEL_COUNTRY", "TW_VESSEL"."VESSEL_CLASS", "TW_VESSEL"."VESSEL_UN_NO", "TW_VESSEL"."VESSEL_CAPTAIN_NAME", "TW_VESSEL"."VESSEL_MASTER_STATUS", "TW_VESSEL"."VESSEL_NOTES", "TW_VESSEL"."VESSEL_CAPACITY", "TW_VESSEL"."FLAG", "TW_VESSEL"."VESSEL_GT", "TW_VESSEL"."VESSEL_NT"FROM "TW_VESSEL"]]> </queryString> <field name="VESSEL_ID" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="VESSEL_ID"/> </field> <field name="VESSEL_IMO_NO" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="VESSEL_IMO_NO"/> </field> <field name="VESSEL_CODE" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="VESSEL_CODE"/> </field> <field name="VESSEL_NAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="VESSEL_NAME"/> </field> <field name="VESSEL_TYPE" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="VESSEL_TYPE"/> </field> <field name="VESSEL_OPERATOR" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="VESSEL_OPERATOR"/> </field> <field name="VESSEL_COUNTRY" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="VESSEL_COUNTRY"/> </field> <field name="VESSEL_CLASS" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="VESSEL_CLASS"/> </field> <field name="VESSEL_UN_NO" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="VESSEL_UN_NO"/> </field> <field name="VESSEL_CAPTAIN_NAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="VESSEL_CAPTAIN_NAME"/> </field> <field name="VESSEL_MASTER_STATUS" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="VESSEL_MASTER_STATUS"/> </field> <field name="VESSEL_NOTES" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="VESSEL_NOTES"/> </field> <field name="VESSEL_CAPACITY" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.label" value="VESSEL_CAPACITY"/> </field> <field name="FLAG" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="FLAG"/> </field> <field name="VESSEL_GT" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.label" value="VESSEL_GT"/> </field> <field name="VESSEL_NT" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.label" value="VESSEL_NT"/> </field> <background> <band splitType="Stretch"/> </background> <title> <band height="79" splitType="Stretch"> <staticText> <reportElement x="227" y="20" width="100" height="30" uuid="7226a73c-5af2-484c-aa55-38e7e3f250d6"/> <text><![CDATA[Test Report]]></text> </staticText> </band> </title> <pageHeader> <band height="41" splitType="Stretch"> <textField> <reportElement x="269" y="11" width="100" height="30" uuid="71666bad-ec66-4744-960b-d31a19b7406b"/> <textFieldExpression> <![CDATA[$P{testparam}]]> </textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="61" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="37" height="30" uuid="297a42f7-5fc7-469a-9b4a-41a630bbf439"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a0e76a04-8150-43f6-a33d-8482a2e3cca1"/> </reportElement> <text><![CDATA[VESSEL_ID]]></text> </staticText> <staticText> <reportElement x="37" y="0" width="37" height="30" uuid="33320ab9-5804-4a4f-80a0-9808b4d60471"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="21991dec-f704-43d9-83b7-572cd19346fb"/> </reportElement> <text><![CDATA[VESSEL_IMO_NO]]></text> </staticText> <staticText> <reportElement x="74" y="0" width="37" height="30" uuid="1e37353b-eac1-4e2e-bd8f-7ff18d79d23a"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0d441aab-a6b6-46c5-aa69-95777101556c"/> </reportElement> <text><![CDATA[VESSEL_CODE]]></text> </staticText> <staticText> <reportElement x="111" y="0" width="37" height="30" uuid="3d6db6e2-5a2e-4253-9110-e74c010e3bf5"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="547853fd-1fb4-4e0d-970a-829f8c88838d"/> </reportElement> <text><![CDATA[VESSEL_NAME]]></text> </staticText> <staticText> <reportElement x="148" y="0" width="37" height="30" uuid="927bcc85-5b66-4762-a042-9da840e54e97"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="040d1dcc-0586-4d35-93af-75ec39150e61"/> </reportElement> <text><![CDATA[VESSEL_TYPE]]></text> </staticText> <staticText> <reportElement x="185" y="0" width="37" height="30" uuid="57657eb5-764d-4d63-9fa9-4958604fa332"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7147f345-6ee0-4fa2-b91c-a257c5c42bc3"/> </reportElement> <text><![CDATA[VESSEL_OPERATOR]]></text> </staticText> <staticText> <reportElement x="222" y="0" width="37" height="30" uuid="82032f3e-9d38-45ee-a42e-bc12c505db42"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="78082193-5188-4716-b69e-4060da2b5dd3"/> </reportElement> <text><![CDATA[VESSEL_COUNTRY]]></text> </staticText> <staticText> <reportElement x="259" y="0" width="37" height="30" uuid="993ad54f-abbe-4141-9b4f-f0ac81841a3b"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d66b9271-7add-4dcc-8b0d-473c101ef7ab"/> </reportElement> <text><![CDATA[VESSEL_CLASS]]></text> </staticText> <staticText> <reportElement x="296" y="0" width="37" height="30" uuid="f4f973ae-bd32-42df-8a6a-d3ee14723b9c"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c8acfaaa-b1ca-40fa-a900-a3adc9c8e396"/> </reportElement> <text><![CDATA[VESSEL_UN_NO]]></text> </staticText> <staticText> <reportElement x="333" y="0" width="37" height="30" uuid="bf0db8a6-6208-49e6-947f-fd9a72caefd4"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="cf513d80-0249-40dc-880d-ac4f0996ed26"/> </reportElement> <text><![CDATA[VESSEL_CAPTAIN_NAME]]></text> </staticText> <staticText> <reportElement x="370" y="0" width="37" height="30" uuid="4fa314b5-b418-4536-a66b-7190652d9998"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0ff74137-6a61-47ea-ad99-743d1d7826a2"/> </reportElement> <text><![CDATA[VESSEL_MASTER_STATUS]]></text> </staticText> <staticText> <reportElement x="407" y="0" width="37" height="30" uuid="62bda25b-e2f8-4855-8df1-f1e25c37b6a8"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="8f8641c3-fde2-4b4d-a7c7-17c5747ae3f3"/> </reportElement> <text><![CDATA[VESSEL_NOTES]]></text> </staticText> <staticText> <reportElement x="444" y="0" width="37" height="30" uuid="ce926a4f-f923-4d66-8779-1bc149266996"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="9c4da5ed-1989-4f8b-89d2-9a81a0820e1c"/> </reportElement> <text><![CDATA[VESSEL_CAPACITY]]></text> </staticText> <staticText> <reportElement x="481" y="0" width="37" height="30" uuid="5e529e73-c561-4e01-9dba-eb44dfbd645c"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="f01fb98b-466a-4663-a482-f00c755656ac"/> </reportElement> <text><![CDATA[FLAG]]></text> </staticText> <staticText> <reportElement x="518" y="0" width="37" height="30" uuid="957e4eed-4388-404c-bd73-eb02e7b471d4"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="fd7ba14c-4abb-40a8-986c-d7522e15b387"/> </reportElement> <text><![CDATA[VESSEL_GT]]></text> </staticText> </band> </columnHeader> <detail> <band height="125" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="37" height="30" uuid="53cb6255-1fed-4ec3-a86a-e1f557a22f20"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a0e76a04-8150-43f6-a33d-8482a2e3cca1"/> </reportElement> <textFieldExpression> <![CDATA[$F{VESSEL_ID}]]> </textFieldExpression> </textField> <textField> <reportElement x="37" y="0" width="37" height="30" uuid="78b24e7d-f746-4698-a9ed-9ba3bb039b3a"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="21991dec-f704-43d9-83b7-572cd19346fb"/> </reportElement> <textFieldExpression> <![CDATA[$F{VESSEL_IMO_NO}]]> </textFieldExpression> </textField> <textField> <reportElement x="74" y="0" width="37" height="30" uuid="ce46d181-c04b-4ed0-a4b7-b48ddab6e7a9"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0d441aab-a6b6-46c5-aa69-95777101556c"/> </reportElement> <textFieldExpression> <![CDATA[$F{VESSEL_CODE}]]> </textFieldExpression> </textField> <textField> <reportElement x="111" y="0" width="37" height="30" uuid="7dc52ee6-dff8-4427-a1ce-5695dd6809e6"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="547853fd-1fb4-4e0d-970a-829f8c88838d"/> </reportElement> <textFieldExpression> <![CDATA[$F{VESSEL_NAME}]]> </textFieldExpression> </textField> <textField> <reportElement x="148" y="0" width="37" height="30" uuid="d50887bb-d695-4bf1-a041-b73527a072a9"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="040d1dcc-0586-4d35-93af-75ec39150e61"/> </reportElement> <textFieldExpression> <![CDATA[$F{VESSEL_TYPE}]]> </textFieldExpression> </textField> <textField> <reportElement x="185" y="0" width="37" height="30" uuid="7240d956-fdf5-445a-ada1-fe67c449a582"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7147f345-6ee0-4fa2-b91c-a257c5c42bc3"/> </reportElement> <textFieldExpression> <![CDATA[$F{VESSEL_OPERATOR}]]> </textFieldExpression> </textField> <textField> <reportElement x="222" y="0" width="37" height="30" uuid="664d6b24-b2ce-4212-98f3-4433298306fc"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="78082193-5188-4716-b69e-4060da2b5dd3"/> </reportElement> <textFieldExpression> <![CDATA[$F{VESSEL_COUNTRY}]]> </textFieldExpression> </textField> <textField> <reportElement x="259" y="0" width="37" height="30" uuid="21932d65-886e-4084-ac5a-722715a9941c"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d66b9271-7add-4dcc-8b0d-473c101ef7ab"/> </reportElement> <textFieldExpression> <![CDATA[$F{VESSEL_CLASS}]]> </textFieldExpression> </textField> <textField> <reportElement x="296" y="0" width="37" height="30" uuid="f0edd8b0-eb82-4228-a4fd-4acd497c91d9"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c8acfaaa-b1ca-40fa-a900-a3adc9c8e396"/> </reportElement> <textFieldExpression> <![CDATA[$F{VESSEL_UN_NO}]]> </textFieldExpression> </textField> <textField> <reportElement x="333" y="0" width="37" height="30" uuid="2468931a-2dd4-4ca6-84f8-be449386df15"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="cf513d80-0249-40dc-880d-ac4f0996ed26"/> </reportElement> <textFieldExpression> <![CDATA[$F{VESSEL_CAPTAIN_NAME}]]> </textFieldExpression> </textField> <textField> <reportElement x="370" y="0" width="37" height="30" uuid="0eafd016-15c4-4f11-a291-9dd96545b652"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0ff74137-6a61-47ea-ad99-743d1d7826a2"/> </reportElement> <textFieldExpression> <![CDATA[$F{VESSEL_MASTER_STATUS}]]> </textFieldExpression> </textField> <textField> <reportElement x="407" y="0" width="37" height="30" uuid="4c8a9db6-6e89-4dc4-b914-0fdd4420676d"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="8f8641c3-fde2-4b4d-a7c7-17c5747ae3f3"/> </reportElement> <textFieldExpression> <![CDATA[$F{VESSEL_NOTES}]]> </textFieldExpression> </textField> <textField> <reportElement x="444" y="0" width="37" height="30" uuid="328aa07c-c172-45a3-9592-19acc8731d96"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="9c4da5ed-1989-4f8b-89d2-9a81a0820e1c"/> </reportElement> <textFieldExpression> <![CDATA[$F{VESSEL_CAPACITY}]]> </textFieldExpression> </textField> <textField> <reportElement x="481" y="0" width="37" height="30" uuid="e0dd3ca4-608f-45a2-9e32-5733be225e79"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="f01fb98b-466a-4663-a482-f00c755656ac"/> </reportElement> <textFieldExpression> <![CDATA[$F{FLAG}]]> </textFieldExpression> </textField> <textField> <reportElement x="518" y="0" width="37" height="30" uuid="49a5006d-64c5-4215-91e2-28ef3e6cbeb3"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="fd7ba14c-4abb-40a8-986c-d7522e15b387"/> </reportElement> <textFieldExpression> <![CDATA[$F{VESSEL_GT}]]> </textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="45" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="54" splitType="Stretch"/> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary></jasperReport>[/code]While calling this report in java , at line code " JasperPrint jasperPrint = JasperFillManager.fillReport(report, parameters, con);: i am getting below error : Oct 11, 2018 12:11:13 PM net.sf.jasperreports.engine.util.JRStyledTextParser <clinit>SEVERE: Error while loading available fontsnet.sf.jasperreports.engine.JRRuntimeException: javax.xml.parsers.ParserConfigurationException at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.<init>(SimpleFontExtensionHelper.java:156) at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.getInstance(SimpleFontExtensionHelper.java:131) at net.sf.jasperreports.engine.fonts.FontExtensionsRegistry.ensureFontExtensions(FontExtensionsRegistry.java:80) at net.sf.jasperreports.engine.fonts.FontExtensionsRegistry.getExtensions(FontExtensionsRegistry.java:57) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:130) at net.sf.jasperreports.engine.util.JRStyledTextParser.<clinit>(JRStyledTextParser.java:86) at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:116) at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:79) at net.sf.jasperreports.engine.fill.JRFiller.createBandReportFiller(JRFiller.java:251) at net.sf.jasperreports.engine.fill.JRFiller.createReportFiller(JRFiller.java:272) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:114) at net.sf.jasperreports.engine.JasperFillManager.fillToFile(JasperFillManager.java:165) at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:771) at view.JasperCall.main(JasperCall.java:51)Caused by: javax.xml.parsers.ParserConfigurationException at oracle.xml.jaxp.JXDocumentBuilderFactory.setFeature(JXDocumentBuilderFactory.java:376) at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.<init>(SimpleFontExtensionHelper.java:149) ... 13 moreException in thread "main" java.lang.ExceptionInInitializerError at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:116) at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:79) at net.sf.jasperreports.engine.fill.JRFiller.createBandReportFiller(JRFiller.java:251) at net.sf.jasperreports.engine.fill.JRFiller.createReportFiller(JRFiller.java:272) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:114) at net.sf.jasperreports.engine.JasperFillManager.fillToFile(JasperFillManager.java:165) at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:771) at view.JasperCall.main(JasperCall.java:51)Caused by: net.sf.jasperreports.engine.JRRuntimeException: javax.xml.parsers.ParserConfigurationException at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.<init>(SimpleFontExtensionHelper.java:156) at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.getInstance(SimpleFontExtensionHelper.java:131) at net.sf.jasperreports.engine.fonts.FontExtensionsRegistry.ensureFontExtensions(FontExtensionsRegistry.java:80) at net.sf.jasperreports.engine.fonts.FontExtensionsRegistry.getExtensions(FontExtensionsRegistry.java:57) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:130) at net.sf.jasperreports.engine.util.JRStyledTextParser.<clinit>(JRStyledTextParser.java:86) ... 8 moreCaused by: javax.xml.parsers.ParserConfigurationException at oracle.xml.jaxp.JXDocumentBuilderFactory.setFeature(JXDocumentBuilderFactory.java:376) at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.<init>(SimpleFontExtensionHelper.java:149) ... 13 moreProcess exited with exit code 1.[/code]I my application I a, using below jars:jasperreports-6.7.0commons-digester-2.1 Kindly help me to solve this issue . ThanksRohit Link to comment Share on other sites More sharing options...
rohitit3031 Posted October 11, 2018 Author Share Posted October 11, 2018 Plase help me find out the root cause of this issue. Link to comment Share on other sites More sharing options...
reportdev Posted October 12, 2018 Share Posted October 12, 2018 try adding jasperreports-fonts dependency. <!-- https://mvnrepository.com/artifact/net.sf.jasperreports/jasperreports-fonts --><dependency> <groupId>net.sf.jasperreports</groupId> <artifactId>jasperreports-fonts</artifactId> <version>6.0.0</version></dependency>[/code] Link to comment Share on other sites More sharing options...
rohitit3031 Posted October 15, 2018 Author Share Posted October 15, 2018 I tried this but still getting same issue .Just wanted to tell you guys, if i use lower vesrion jar(( in my case i used jasperrepsort4.0.1 nad jasper-font-4.0.1 jar) i didn't got error but while using jasperreports-6.7.0 jar i am getting font error . So is there any specific version that we have to use with jdeveloper 12c ide. Kindly do let me know.Thanks in advanceRohit Link to comment Share on other sites More sharing options...
rdominguez_2 Posted April 28, 2023 Share Posted April 28, 2023 That solution never worked for me, does anyone have another solution? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now