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.png)
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);
}
}
