chris.manikjr Posted October 11, 2016 Share Posted October 11, 2016 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 exceptionsHere 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 Codepublic 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);}} 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