Infinite loop

2001 JI Open Discussion · August 14, 2006

By: Shiva Murali - shivva

Infinite loop

2002-05-19 20:34

Hi..

with jasper 0.2.5 if a field overflows then itz getting truncated. But with jasper 3 , if a field overflows, the scriptlet is entering into an infinite loop. can anyone help on this regard.

thanks

shivva..

By: Teodor Danciu - teodord

RE: Infinite loop

2002-05-19 23:53

Hi,

I'll try to look into this.

Maybe you could send me your XML report design

and the scriptlet class.

Thanks,

Teodor

By: Shiva Murali - shivva

RE: Infinite loop

2002-05-20 00:58

Here is my xml and the scriptlet class.

It gets in to infinte loop when the field "otherterms" overflows. its a blob field.

gets into infinte loop with the latest jasper (3.0).

888888888888888888888888888888888888888888

XML

888888888888888888888888888888888888888888

<?xml version="1.0"?>

<!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://www.jasperreports.com/dtds/jasperreport-0.2.5.dtd">

<jasperReport

name="ctrfile_print"

printOrder="Vertical"

pageWidth="595"

pageHeight="900"

leftMargin="20"

rightMargin="20"

topMargin="2"

bottomMargin="2"

isTitleNewPage="false"

isSummaryNewPage="false"

scriptletClass=" com.justcommodity.cxc.utils.ContractPrintScriptlet">

($P{memberId}.toString().equals($F{byrid}.toString()))?"bought from" :(($P{memberId}.toString().equals($F{slrid}.toString()))?"sold to":"***")

</variableExpression>

</variable>

<title>

</textElement>

<textFieldExpression class="java.lang.String">$V{companyname}</textFieldExpression>

</textField>

</textElement>

<textFieldExpression class="java.lang.String">$V{companyaddr}</textFieldExpression>

</textField>

</textElement>

<textFieldExpression class="java.lang.String">"Tel : "+$V{companytel}+" Fax : "+$V{companyfax}+" Tlx : "+$V{companytlx}</textFieldExpression>

</textField>

<line>

</line>

</band>

</title>

</band>

</pageHeader>

</band>

</columnHeader>

</textElement>

<textFieldExpression class="java.lang.String">($P{memberId}.toString().equals($F{byrid}.toString()))?"PURCHASE CONTRACT" :(($P{memberId}.toString().equals($F{slrid}.toString()))?"SALE CONTRACT":"NONE")</textFieldExpression>

</textField>

</textElement>

<textFieldExpression class="java.lang.String">$V{cpaddr}</textFieldExpression>

</textField>

</textElement>

<textFieldExpression class="java.lang.String">"Contract No : " + $F{ctrref}</textFieldExpression>

</textField>

</textElement>

<text>Contract Date :</text>

</staticText>

</textElement>

$F{ctrdate}

</textFieldExpression>

</textField>

</textElement>

<textFieldExpression class="java.lang.String">"We are pleased to confirm having "+$V{tempvar1}+" you under the following terms and conditions :"</textFieldExpression>

</textField>

</textElement>

<text>-- COMMODITY SPECIFICATIONS --</text>

</staticText>

</textElement>

<textFieldExpression class="java.lang.String">$V{commodity}</textFieldExpression>

</textField>

</textElement>

"As Per Standard "+ $V{specname}+ " specs :"

</textFieldExpression>

</textField>

</textElement>

$V{specdet}

</textFieldExpression>

</textField>

</textElement>

"-- ORIGIN-- "+$V{origin}

</textFieldExpression>

</textField>

</textElement>

"-- PRICE -- "+($F{currencyid})+" " +new DecimalFormat("0.00").format($F{ctrprice}.doubleValue())+" Per "+$V{unitdesc}+", BASIS "+$F{ctrbasisid}+" " +$V{destport}+", "+$V{destportcntry}

</textFieldExpression>

</textField>

</textElement>

"-- QUANTITY -- "+ java.lang.String.valueOf(java.lang.Math.round(($F{quantity}).doubleValue()))+" "+$V{unitdesc}+", In "+$F{packing}

</textFieldExpression>

</textField>

</textElement>

"-- SHIPMENT -- "+$V{duringarival}+" "+$F{shipmonth}

</textFieldExpression>

</textField>

</textElement>

"-- PAYMENT -- "+$V{payterms}

</textFieldExpression>

</textField>

</textElement>

"-- LOADPORT -- ANY "+$V{blorigin}+" PORT"

</textFieldExpression>

</textField>

</textElement>

<text>-- OTHERS TERMS --</text>

</staticText>

</textElement>

$V{otherterms}

</textFieldExpression>

</textField>

</band>

</detail>

</band>

</columnFooter>

</band>

</pageFooter>

</textElement>

<text>Please stamp , sign and return to us the duplicate copy. </text>

</staticText>

</textElement>

<textFieldExpression class="java.lang.String">$V{companyname}</textFieldExpression>

</textField>

</textElement>

<text>CONFIRMED ACCEPTANCE</text>

</staticText>

</textElement>

</staticText>

</textElement>

</staticText>

</textElement>

<textFieldExpression class="java.lang.String">$V{footrfld1}</textFieldExpression>

</textField>

</textElement>

<textFieldExpression class="java.lang.String">$V{footrfld2}</textFieldExpression>

</textField>

</band>

</summary>

</jasperReport>

888888888888888888888888888888888888888888

SCRIPTLET

888888888888888888888888888888888888888888

package com.justcommodity.cxc.utils;

/**

* Title:

* Description:

* Company: Oilgrains Venture Asia Pacific Pte Ltd

* @author S.Murali

* @version 1.0

*/

import dori.jasper.engine.*;

import java.sql.*;

import java.util.*;

import java.math.BigDecimal;

import javax.naming.InitialContext;

import javax.sql.DataSource;

import java.util.*;

import javax.rmi.PortableRemoteObject;

import java.text.DecimalFormat;

/**

*

*/

public class ContractPrintScriptlet extends JRDefaultScriptlet {

private String ctrid = new String();

private String mbrid = new String();

private String company = new String();

private Connection con = null;

/**

*

*/

public void beforeReportInit() throws JRScriptletException

{

System.out.println("BeforeReportInit***");

this.ctrid = (String)this.getParameterValue("contractId");

this.mbrid = (String)this.getParameterValue("memberId");

this.con = openConnection();

System.out.println("Connection initialized...........");

}

/**

*

*/

public void afterReportInit() throws JRScriptletException

{

System.out.println("AfterReportInit***");

}

/**

*

*/

public void beforePageInit() throws JRScriptletException

{

System.out.println("BeforePageInit***" );

}

/**

*

*/

public void afterPageInit() throws JRScriptletException

{

System.out.println("AfterPageInit***" );

setVariables();

}

/**

*

*/

public void beforeColumnInit() throws JRScriptletException

{

System.out.println("BeforeColumnInit***");

}

/**

*

*/

public void afterColumnInit() throws JRScriptletException

{

System.out.println("AfterColumnInit***");

}

/**

*

*/

public void beforeGroupInit(String groupName) throws JRScriptletException

{

System.out.println("BeforeGroupInit***" );

}

/**

*

*/

public void afterGroupInit(String groupName) throws JRScriptletException

{

System.out.println("AfterGroupInit***");

}

/**

*

*/

public void beforeDetailEval() throws JRScriptletException

{

System.out.println("BeforeDetail***");

}

/**

*

*/

public void afterDetailEval() throws JRScriptletException

{

System.out.println("AfterDetail***");

closeConnection();

}

private static Connection openConnection() {

try {

/* String driver ="org.firebirdsql.jdbc.FBDriver";

String connectString = "jdbc:firebirdsql:knuth/3050:/home/firebird/cxcdata-v10.gdb";

String user = "sysdba";//"sa";

String password = "masterkey";//"";

Class.forName(driver);

Connection conn = DriverManager.getConnection(connectString, user, password);

return conn; */

DataSource ds = (DataSource) new InitialContext().lookup("java:comp/env/jdbc/cxcdata");

return ds.getConnection();

}catch(Exception ex) {

ex.printStackTrace();

return null;

}

private void closeConnection() {

try {

this.con.close();

this.con = null;

System.out.println("Connection closed.......");

} catch (Exception ex) {

ex.printStackTrace();

}

private void setVariables() {

try {

String sql1 = "Select mbrname,mbraddress from jcmbr where mbrid = "+this.mbrid;

String sql2 = "Select contactnum from jcmbrcontact where contacttypeid='P' and mbrid = "+this.mbrid;

String sql3 = "Select contactnum from jcmbrcontact where contacttypeid='F' and mbrid = "+this.mbrid;

String sql4 = "Select contactnum from jcmbrcontact where contacttypeid='T' and mbrid = "+this.mbrid;

ResultSet rs = null;

System.out.println(sql1);

if (con == null)

this.con = openConnection();

rs = con.createStatement().executeQuery(sql1);

if (rs == null || !rs.next()){

this.setVariableValue("companyname","*");

this.setVariableValue("companyaddr","*");

}else{

this.setVariableValue("companyname",rs.getString("mbrname"));

this.setVariableValue("companyaddr",formatAddress(rs.getString("mbraddress").trim(),"n"));

rs.close();

}

System.out.println(sql2);

rs = con.createStatement().executeQuery(sql2);

if (rs == null || !rs.next()){

this.setVariableValue("companytel","*");

}else{

this.setVariableValue("companytel",rs.getString("contactnum"));

rs.close();

}

System.out.println(sql3);

rs = con.createStatement().executeQuery(sql3);

if (rs == null || !rs.next()){

this.setVariableValue("companyfax","*");

}else{

this.setVariableValue("companyfax",rs.getString("contactnum"));

rs.close();

}

System.out.println(sql4);

rs = con.createStatement().executeQuery(sql4);

if (rs == null || !rs.next()){

this.setVariableValue("companytlx","*");

}else{

this.setVariableValue("companytlx",rs.getString("contactnum"));

rs.close();

}

this.company = this.getVariableValue("companyname").toString();

if(this.getParameterValue("memberId").toString().trim().equals(this.getFieldValue("slrid").toString().trim())){

this.setVariableValue("footrfld1","SELLER");

this.setVariableValue("footrfld2","BUYER");

}else if(this.getParameterValue("memberId").toString().trim().equals(this.getFieldValue("byrid").toString().trim())){

this.setVariableValue("footrfld1","BUYER");

this.setVariableValue("footrfld2","SELLER");

}

this.setVariableValue("companyname",this.company);

System.out.println("Seller id:"+this.getFieldValue("slrid"));

if (this.mbrid.equals(this.getFieldValue("slrid").toString().trim()))

this.setVariableValue("cpaddr",getAddress(this.getFieldValue("byrid").toString()));

else

this.setVariableValue("cpaddr",getAddress(this.getFieldValue("slrid").toString()));

String sql = "Select commodityname from jccommodity where commodityid = '"+ this.getFieldValue("commodityid")+"'";

System.out.println(sql);

rs = con.createStatement().executeQuery(sql);

if (rs == null || !rs.next()){

this.setVariableValue("commodity","NONE");

}else{

this.setVariableValue("commodity",rs.getString("COMMODITYNAME"));

rs.close();

}

this.setVariableValue("specdet",getSpecDet());

sql = "select jccountry.countryname from "+

" ctrorigin,jccountry where ctrorigin.countryid = jccountry.countryid "+

" and ctrorigin.ctrid = "+this.ctrid;

System.out.println(sql);

rs = con.createStatement().executeQuery(sql);

if (rs == null || !rs.next()){

this.setVariableValue("origin","NONE");

}else{

this.setVariableValue("origin",rs.getString("COUNTRYNAME"));

rs.close();

}

sql = "Select commodityname from jccommodity where commodityid = '"+ this.getFieldValue("commodityid")+"'";

System.out.println(sql);

rs = con.createStatement().executeQuery(sql);

if (rs == null || !rs.next()){

this.setVariableValue("commodity","NONE");

}else{

this.setVariableValue("commodity",rs.getString("COMMODITYNAME"));

rs.close();

}

sql ="select portname,countryname from ctrcfmdport,jcport,jccountry "+

"where ctrcfmdport.portid = jcport.portid and jcport.countryid = jccountry.countryid "+

" and ctrid = "+this.ctrid;

System.out.println(sql);

rs = con.createStatement().executeQuery(sql);

if (rs == null || !rs.next()){

this.setVariableValue("destport","NONE");

this.setVariableValue("destportcntry","NONE");

}else{

this.setVariableValue("destport",rs.getString("PORTNAME"));

this.setVariableValue("destportcntry",rs.getString("COUNTRYNAME"));

rs.close();

}

sql ="select isduring from ctrcnfstatus "+

"where ctrid = "+this.ctrid;

System.out.println(sql);

rs = con.createStatement().executeQuery(sql);

if (rs == null || !rs.next()){

this.setVariableValue("duringarival","NONE");

}else{

this.setVariableValue("duringarival",new String(rs.getBoolean("ISDURING")== true ?"DURING":"ARRIVAL"));

rs.close();

}

sql ="select portname,countryname from ctrcfmdport,jcport,jccountry "+

"where ctrcfmdport.portid = jcport.portid and jcport.countryid = jccountry.countryid "+

" and ctrid = "+this.ctrid;

System.out.println(sql);

rs = con.createStatement().executeQuery(sql);

if (rs == null || !rs.next()){

this.setVariableValue("destport","NONE");

this.setVariableValue("destportcntry","NONE");

}else{

this.setVariableValue("destport",rs.getString("PORTNAME"));

this.setVariableValue("destportcntry",rs.getString("COUNTRYNAME"));

rs.close();

}

sql ="select paymethoddescn from jcpayterms a,jcpaymentmethod b "+

" where a.paytype = b.paymethodid and paytermid = "+this.getFieldValue("paytermid");

System.out.println(sql);

rs = con.createStatement().executeQuery(sql);

if (rs == null || !rs.next()){

this.setVariableValue("payterms","NONE");

}else{

this.setVariableValue("payterms",rs.getString("PAYMETHODDESCN"));

rs.close();

}

sql ="Select maindesc from jccnfterms a,ctrcnfterms b where a.cnftermid = b.cnftermid and b.ctrid = "+this.ctrid;

System.out.println(sql);

rs = con.createStatement().executeQuery(sql);

if (rs == null || !rs.next()){

this.setVariableValue("otherterms","NONE");

}else{

String descn = rs.getString("MAINDESC");

this.setVariableValue("otherterms",(descn == null ? "-NULL-":descn));

rs.close();

}

sql ="select countryname from ctrcnfstatus a,jccountry b "+

" where a.blorigin = b.countryid and a.ctrid = "+this.ctrid;

System.out.println(sql);

rs = con.createStatement().executeQuery(sql);

if (rs == null || !rs.next()){

this.setVariableValue("blorigin","NONE");

}else{

this.setVariableValue("blorigin",rs.getString("COUNTRYNAME"));

rs.close();

}

sql ="select qtydescn from jcqtyunit "+

" where qtyunitid = '"+this.getFieldValue("qtyunit")+"'";

System.out.println(sql);

rs = con.createStatement().executeQuery(sql);

if (rs == null || !rs.next()){

this.setVariableValue("unitdesc","NONE");

}else{

this.setVariableValue("unitdesc",rs.getString("QTYDESCN"));

rs.close();

}

sql ="select specname from jccommodityspec a,ctrcfmspec b"+

" where a.specid = b.specid and specseqid = 0 and b.ctrid = "+this.ctrid;

System.out.println(sql);

rs = con.createStatement().executeQuery(sql);

if (rs == null || !rs.next()){

this.setVariableValue("specname","NONE");

}else{

this.setVariableValue("specname",rs.getString("SPECNAME"));

rs.close();

}

} catch (Exception ex) {

ex.printStackTrace();

}

private String getAddress(String cpmbrid) {

try {

ResultSet rs = null;

String sql = "Select mbrname,mbraddress from jcmbr where mbrid = "+cpmbrid;

System.out.println(sql);

String addr = new String();

if (con == null)

con = openConnection();

rs = con.createStatement().executeQuery(sql);

if (rs == null || !rs.next()){

return "NONE";

}else{

addr = rs.getString("MBRNAME");

addr = addr + "n" + rs.getString("MBRADDRESS");

rs.close();

}

System.out.println("Address:n"+addr);

return addr.trim();

} catch (Exception ex) {

ex.printStackTrace();

return null;

}

private String getSpecDet() {

try {

String sql = "select d.specid,d.specname, specmin, specmax,specunit from"+

" jcspecdetails d, jccommodityspec m,ctrcfmspec r where" +

" r.ctrid = "+this.ctrid +" and r.specid = m.specid and m.specid = d.specid ";

System.out.println(sql);

StringBuffer spec = new StringBuffer("");

if (con == null)

con = openConnection();

ResultSet rs = con.createStatement().executeQuery(sql);

if (rs == null || !rs.next())

return "NONE";

do {

BigDecimal min = rs.getBigDecimal("SPECMIN");

BigDecimal max = rs.getBigDecimal("SPECMAX");

String unit = rs.getString("SPECUNIT");

String name = padBlanks(rs.getString("SPECNAME"),20,'B');

System.out.println(name);

if (unit == null )

unit = "-nill-";

else if (unit.trim().equals("%"))

unit = "PCT";

DecimalFormat fmt = (DecimalFormat)java.text.NumberFormat.getInstance();

fmt.setDecimalSeparatorAlwaysShown(true);

fmt.applyPattern("0.00");

if (min != null){

spec.append(name).append(padBlanks(fmt.format(min.doubleValue()),8,'F')).append(" ").append(padBlanks(unit,10,'B')).append(" ").append(" MIN");

System.out.println(spec.toString());

}

if (max != null) {

max = new BigDecimal(java.lang.Math.round(max.doubleValue()));

spec.append("n").append(name).append(padBlanks(fmt.format(max.doubleValue()),8,'F')).append(" ").append(padBlanks(unit,10,'B')).append(" ").append(" MAX").append("n");

System.out.println(spec.toString());

}

}while(rs.next());

rs.close();

return spec.toString();

} catch (Exception e) {

e.printStackTrace();

return null;

}

private String padBlanks(String str,int size,char flag) {

if (str == null)

str = new String("-nill-");

else

str = str.trim();

System.out.println(str.length());

int len = str.length();

if (flag == 'B') {

for(int i=0;i<=size- len;i++)

str = str + " ";

}else if (flag =='F') {

String tmp = new String();

for(int i=0;i<=size- len;i++)

tmp = tmp + " ";

str = tmp+str;

}

return str;

}

private String formatAddress(String srcAddr,String delim) {

try {

StringTokenizer tokens = new StringTokenizer(srcAddr,delim);

String dstAddr = new String();

while(tokens.hasMoreTokens())

dstAddr = dstAddr+ " "+tokens.nextToken().trim();

return dstAddr;

} catch (Exception ex) {

ex.printStackTrace();

return null;

}

Sign In

Infinite loop

Recommended Posts

2001 JI Open Discussion

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore