[Print summery band if Detail band overflows]

Hello Team Members ,

 

Kindly help me to solve this issue.

 

Thank

Rohit 

 

[Print summery band if Detail band overflows]

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

[Print summery band if Detail band overflows]

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 

[report generation issue]

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 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

[Need infomation regarding Jasper soft 6.5.1 Final community edition for development]

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

 

 

[SEVERE: Error while loading available fonts]

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

[SEVERE: Error while loading available fonts]

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

 

[Not able to connect to oracle database]

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

 

 

[SEVERE: Error while loading available fonts]

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

 

[Not able to connect to oracle database]

Kindy suggest community member

[Not able to connect to oracle database]

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