rohitit3031

Hello Team Members , Kindly help me to solve this issue. Thank Rohit

Just wanted update For this I kept Split type property of detail band as 'Prevent' . --(Is this work in rerport ?) . - this option is not working . My report data is flowing to next page . Kindly suggest . Thanks

Hi , I have requirement in my report as below : 1: Detail band data should not print in next page if detail band data overflows . I mean detail band data should come in first page only becasue in my report i have genearte only 1 page . Remaing detail information I am showing in summery band .For this I kept Split type property of detail band as 'Prevent' . --(Is this work in rerport ?) . 2: If detail band overflows then only Summery band data prints otherwise it should not print in pdf . Kindly tell me how to achive this Thanks Rohit

Hi Team , I Have created an application for generating Jasper Report .In that application , I have created a servlet that is calling jrxml report and exporting it to PDF formet .That application i have deployed as a EAR on weblogic server . In my local server it is running fine while executing servlet through URL .But on server it is giving me error while exporting report to PDF file . Below is code , dev server exception log and URL to access servel . APP URL : http://localhost:7101/RestApiJasperCallApi/reportServlet?BOOKING_ID="123123123" Server log: ####<Apr 15, 2019, 9:07:18,306 AM UTC> <Error> <HTTP> <twjcs-wls-1.compute-603777986.oraclecloud.internal> <TWJCS_do_server_1> <[ACTIVE] ExecuteThread: '25' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <8c851a43-c92e-40df-8c85-94090c59ed45-0001fea8> <1555319238306> <[severity-value: 8] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-101017> <[servletContext@512052688[app:RestApiJasperCallApi module:RestApiJasperCallApi path:null spec-version:3.1]] Root cause of ServletException. java.lang.NullPointerException at net.sf.jasperreports.engine.JRAbstractExporter.ensureInput(JRAbstractExporter.java:692) at net.sf.jasperreports.engine.export.JRPdfExporter.exportReport(JRPdfExporter.java:503) at net.sf.jasperreports.engine.JasperExportManager.exportToPdfStream(JasperExportManager.java:198) at net.sf.jasperreports.engine.JasperExportManager.exportReportToPdfStream(JasperExportManager.java:535) at view.servlets.ReportServlet.doGet(ReportServlet.java:68) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) I am using Jasper soft 6.5.1 final version for creating jasper report . and below jars in my application : 1:jasperreport 5.6.0 , jasperreport-font-5.6.0, IText -2.1.7.js2 , Common-Digester-2.1 , Jdt-compiler-3.1.1 , Xml-api-ext, Xml-apis. CODE :: public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String parameter = request.getParameter("BOOKING_ID"); JasperPrint jasPrint = null; try { jasPrint = generateJasperReprotPrint(); } catch (JRException | SQLException e) { } System.out.println("jasPrint +jasPrint" + jasPrint); String file = "TEST.pdf"; ServletOutputStream sos = response.getOutputStream(); response.setContentType("application/pdf"); try { JasperExportManager.exportReportToPdfStream(jasPrint, sos); -- I am getting exception here in dev server but in local server it is working fine . } catch (JRException e) { System.out.println(e.getMessage()); e.printStackTrace(); } } public JasperPrint generateJasperReprotPrint() throws SQLException, JRException, FileNotFoundException, MalformedURLException { System.out.println(" getServletContext() " + getServletContext()); InputStream is = getServletContext().getResourceAsStream("/jasperreports/zzzzz.jrxml"); InputStream is1 = getServletContext().getResourceAsStream("/jasperreports/yyyy.jrxml"); JasperDesign jasperDesign1 = JRXmlLoader.load(is); JasperDesign jasperDesign2 = JRXmlLoader.load(is1); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@xxxxxxxxx/xxxxxxxxxxx", "xxxx", "xxx"); JasperReport report = JasperCompileManager.compileReport(jasperDesign1); JasperReport report2 = JasperCompileManager.compileReport(jasperDesign2); Map parameters = new HashMap(); parameters.put("blNumberParam", "111"); parameters.put("bookingIdParam", "2222-0009"); parameters.put("BlHeaderTitleParam", "abc"); parameters.put("subreportparamtest", report2); System.out.println("--+" + parameters + "---" + con); JasperPrint jasperPrint = JasperFillManager.fillReport(report, parameters, con); return jasperPrint; } Please help . Thanks Rohit

Dear Community Members, I am going to use jasper soft studio 6.5.1 final community edition for developing my report for one of my project I have downloaded it from https://community.jaspersoft.com/project/jaspersoft-studio/releases link . I have few question before we start using it: 1: Is this version licence free ? 2: is this support digital signature ? If yes then what is the process and steps to implement it in reports? 3:Is there any chance of getting popup mesages to get licence after using this version for few month ? Kindly suggest . Thanks Rohit Chaturvedi

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 advance Rohit

Plase help me find out the root cause of this issue.

Hi Hozawa , Actaully you are right.I was using wrong syntax to call service name . It is fixed now . But now i am getting one more error. I have already asked question in cummunity for that . Below is the link : https://community.jaspersoft.com/questions/1107931/severe-error-while-loading-available-fonts Can you please help me on that ? Thanks

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.0 commons-digester-2.1 Kindly help me to solve this issue . Thanks Rohit

Kindy suggest community member

Hi , I am trying to connect to oracle data base in jaspersoft studio 6. 6.0 using "oracle.jdbc.driver.OracleDriver" . and i am giving below db details to connect to db : jdbcurl : jdbc:oracle:thin:@172.168.1.1:1521:database Service nameUsername : ABCPASS: ****[/code]while testing i am getting below error : Caused by: java.sql.SQLException: Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor[/code]i am giving databse service name to access db . Kindly help. Thanks Rohit