Hi everybody,
sorry for my bad english :)
I'm trying to generate a pdf file in a java class, I'm using itext 2.0.8,
tomcat 4.1.39 and j2sdk1.4.2_19.
The java code is:
-----------------------------------------------------------CODE-----------------------------------------------------------------------
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileWriter;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.util.Enumeration;
import java.util.Vector;
import com.lowagie.text.Document;
import com.lowagie.text.PageSize;
import com.lowagie.text.Paragraph;
import com.lowagie.text.pdf.*;
import LIBRERIA.sql.SqlEsegui;
import LIBRERIA.utils.AppUtils;
public class CreaFlusso {
public void quadratura(Connection conn)throws Exception{
Document documento = new Document(PageSize.A4);
PdfWriter writer = PdfWriter.getInstance(documento, new
FileOutputStream
("prova.pdf"));
documento.open();
writer.open();
String NM_PRC;
String DT_CHIUSURA;
String DT_VALUTA;
String NR_MTR;
String COD_CAUS;
String COD_INIZ;
String NOMINATIVO;
String IMPORTO;
String SEGNO;
String FIL_CAT_CONTO;
String DT_RIF;
String MESE_RIF;
String DT_SPED;
String sql="select "+
"NM_PRC, "+
"DT_CHIUSURA, "+
"DT_VALUTA, "+
"NR_MTR, "+
"COD_CAUS, "+
"COD_INIZ, "+
"NOMINATIVO, "+
"IMPORTO/100 IMPORTO, "+
"SEGNO, "+
"FIL_CAT_CONTO, "+
"DT_RIF, "+
"MESE_RIF, "+
"DT_SPED "+
"from CIRCOLO_ISP.CIRCOLO_FILE_ADDEBITI "+
"where DT_SPED IS NULL AND ROWNUM <100";
Vector ret = SqlEsegui.eseguiDDLv(conn, sql);
if(ret!=null && ret.size()>0){
Enumeration en = ret.elements();
while(en.hasMoreElements()){
String [] current = (String[])en.nextElement();
NM_PRC = current [0];
DT_CHIUSURA = current [1];
DT_VALUTA = current [2];
NR_MTR = current [3];
COD_CAUS = current [4];
COD_INIZ = current [5];
NOMINATIVO = current [6];
IMPORTO = current [7];
SEGNO = current [8];
FIL_CAT_CONTO = current [9];
DT_RIF = current [10];
MESE_RIF = current [11];
DT_SPED = current [12];
writer.add(new Paragraph("NM_PRC : " + NM_PRC));
writer.add(new Paragraph("DT_CHIUSURA : " +
DT_CHIUSURA));
writer.add(new Paragraph("DT_VALUTA : " +
DT_VALUTA));
writer.add(new Paragraph("NR_MTR : " + NR_MTR));
writer.add(new Paragraph("COD_CAUS : " +
COD_CAUS));
writer.add(new Paragraph("COD_INIZ : " +
COD_INIZ));
writer.add(new Paragraph("NOMINATIVO : " +
NOMINATIVO));
writer.add(new Paragraph("IMPORTO : " +
IMPORTO));
writer.add(new Paragraph("SEGNO : " + SEGNO));
writer.add(new Paragraph("FIL_CAT_CONTO : " +
FIL_CAT_CONTO));
writer.add(new Paragraph("DT_RIF : " + DT_RIF));
writer.add(new Paragraph("MESE_RIF : " +
MESE_RIF));
writer.add(new Paragraph("DT_SPED : " +
DT_SPED));
}
}
writer.close();
documento.close();
}
}
-------------------------------------------------------END
CODE---------------------------------------------------------------------
I'm sure that the query returns 99 records..
Can you help me????????? :(
I always get this error:
---------------------------------------------------------ERROR-----------------------------------------------------------------------
ExceptionConverter: java.io.IOException: The document has no pages.
at com.lowagie.text.pdf.PdfPages.writePageTree(Unknown Source)
at com.lowagie.text.pdf.PdfWriter.close(Unknown Source)
at com.lowagie.text.pdf.PdfDocument.close(Unknown Source)
at com.lowagie.text.pdf.PdfWriter.close(Unknown Source)
at it.sanpaolo.menir.circolo.CreaFlusso.quadratura(CreaFlusso.java:100)
at
org.apache.jsp.CreaFlussoCntr_jsp._jspService(CreaFlussoCntr_jsp.java:311)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:720)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:720)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:145)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:139)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2460)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:119)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:157)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:534)
----------------------------------------------------END
ERROR----------------------------------------------------------------------
PLEASE HELP MEEEEEEEEEEEEEEEEEEE!!!!!!
--
View this message in context:
http://itext-general.2136553.n4.nabble.com/iText-The-document-has-no-pages-error-tp3001718p3001718.html
Sent from the iText - General mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
iText-questions mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/itext-questions
Many questions posted to this list can (and will) be answered with a reference
to the iText book: http://www.itextpdf.com/book/
Please check the keywords list before you ask for examples:
http://itextpdf.com/themes/keywords.php
