JasperReport error HTTP 410 failed to load

0

Hi all. I have a simple report that displays fields from database. I have setup a data adapter in Jasper and put the Query, query have procedure. I can preview the report successfully from Jasper, but when it comes to Java it couldn't compile the report and show the following exceptions

Here is my Jasper report query setting

<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="REPO1" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="0724530b-6cc7-45b0-a683-afb3e929c529">

<property name="com.jaspersoft.studio.data.sql.tables" value=""/>

<property name="com.jaspersoft.studio.data.defaultdataadapter" value="jaja"/>

<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="BRANCHID" class="java.lang.String"/>
<parameter name="STARTDATE" class="java.lang.String"/>
<parameter name="ENDDATE" class="java.lang.String"/>
<parameter name="JOB" class="java.lang.String"/>
<parameter name="TIPE" class="java.lang.String"/>
<parameter name="ORACLE_REF_CURSOR" class="java.sql.ResultSet" isForPrompting="false"/>
<queryString language="plsql">
<![CDATA[{call mufacq.PRC_LAPORAN_PO( $P{BRANCHID}, $P{STARTDATE}, $P{ENDDATE}, $P{JOB}, $P{TIPE}, $P{ORACLE_REF_CURSOR} )}]]>
</queryString>
 
Here is my Java Code
public class reportPO extends GenericForwardComposer<Component>{
Window winReportes;
Jasperreport report;
Iframe frame;
String reportSrc,jrxmlSrc,folder;
Map parameters = new HashMap();
AMedia am,bm;
Connection conn;
 
 
    private Label lblPar1;
    private Label lblPar2;
    private Label lblPar3;
    private Label lblPar4;
    private Label lblPar5;
    @SuppressWarnings("unchecked")
    @Override
    public void doAfterCompose(Component comp) throws Exception {
        super.doAfterCompose(comp);
        String pbranchid=Executions.getCurrent().getParameter("branchid");
        String pjob=Executions.getCurrent().getParameter("job");
        String psdate=Executions.getCurrent().getParameter("start");
        String pedate=Executions.getCurrent().getParameter("end");
        String ptipe=Executions.getCurrent().getParameter("tipe");
        String ptype=Executions.getCurrent().getParameter("type");
        
        lblPar1.setValue(pbranchid);
        lblPar2.setValue(pjob);
        lblPar3.setValue(psdate);
        lblPar4.setValue(pedate);
        lblPar5.setValue(ptipe);
        
//        JasperReport jasperReport = (JasperReport) JRLoader.loadObject(reportSrc);
// jasperReport.setProperty( "net.sf.jasperreports.query.executer.factory.plsql"
//                ,"com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory");
 
conn= OracleConnUtils.getOracleConnection();
folder= Sessions.getCurrent().getWebApp().getRealPath("/WEB-INF/");
reportSrc = Sessions.getCurrent().getWebApp().getRealPath("/jasper/reportPO.jasper");
 
 
parameters.put("BRANCHID", pbranchid);
parameters.put("JOB", pjob);
parameters.put("STARTDATE", psdate);
parameters.put("ENDDATE", pedate);
parameters.put("TIPE", ptipe);
// jrxmlSrc = Sessions.getCurrent().getWebApp().getRealPath("/jasper/data1.jrxml");
System.out.println(parameters);
System.out.println(conn);
System.out.println(reportSrc);
System.out.println(ptype);
report.setParameters(parameters);
report.setDataConnection(conn);
//report.setType((String)format.getSelectedItem().getValue());
report.setType(ptype);
report.setSrc(reportSrc);
}
}
chris.manikjr's picture
Joined: Oct 10 2016 - 9:17pm
Last seen: 2 years 9 months ago

0 Answers:

No answers yet
Feedback