following is the servlet i have use in my application
package report;
import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.io.StringWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.HashMap;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.jasperreports.engine.JasperRunManager;
public class DbDSReportServlet1 extends HttpServlet
{
protected void doGet(HttpServletRequest request, HttpServletResponse
response) throws ServletException, IOException
{
Connection connection;
ServletOutputStream servletOutputStream = response.getOutputStream();
InputStream reportStream =
getServletConfig().getServletContext().getResourceAsStream("/reports/
monthly_custreport.jasper");
System.out.println("report stream "+reportStream);
try
{
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection ("jdbc:mysql://localhost:3307/
marketing","root","root");
System.out.println("Filling report...");
JasperRunManager.runReportToPdfStream(reportStream,servletOutputStream,
new HashMap(), connection);
System.out.println("Done!");
connection.close();
response.setContentType("application/pdf");
servletOutputStream.flush();
servletOutputStream.close();
}
catch (Exception e)
{
// display stack trace in the browser
e.printStackTrace();
}
}
}
*****************
and following is the exception i m getting
net.sf.jasperreports.engine.JRRuntimeException: Unknown hyperlink
target 0
at
net.sf.jasperreports.engine.JRHyperlinkHelper.getLinkTarget(JRHyperlinkHelper.java:
269)
at
net.sf.jasperreports.engine.base.JRBaseTextField.normalizeLinkTarget(JRBaseTextField.java:
313)
at
net.sf.jasperreports.engine.base.JRBaseTextField.readObject(JRBaseTextField.java:
377)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at java.io.ObjectStreamClass.invokeReadObject(Unknown Source)
at java.io.ObjectInputStream.readSerialData(Unknown Source)
at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
at java.io.ObjectInputStream.readObject0(Unknown Source)
at java.io.ObjectInputStream.readObject(Unknown Source)
at java.util.ArrayList.readObject(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at java.io.ObjectStreamClass.invokeReadObject(Unknown Source)
at java.io.ObjectInputStream.readSerialData(Unknown Source)
at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
at java.io.ObjectInputStream.readObject0(Unknown Source)
at java.io.ObjectInputStream.defaultReadFields(Unknown Source)
at java.io.ObjectInputStream.readSerialData(Unknown Source)
at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
at java.io.ObjectInputStream.readObject0(Unknown Source)
at java.io.ObjectInputStream.readArray(Unknown Source)
at java.io.ObjectInputStream.readObject0(Unknown Source)
at java.io.ObjectInputStream.defaultReadFields(Unknown Source)
at java.io.ObjectInputStream.readSerialData(Unknown Source)
at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
at java.io.ObjectInputStream.readObject0(Unknown Source)
at java.io.ObjectInputStream.defaultReadFields(Unknown Source)
at java.io.ObjectInputStream.defaultReadObject(Unknown Source)
at
net.sf.jasperreports.engine.base.JRBaseReport.readObject(JRBaseReport.java:
742)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at java.io.ObjectStreamClass.invokeReadObject(Unknown Source)
at java.io.ObjectInputStream.readSerialData(Unknown Source)
at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
at java.io.ObjectInputStream.readObject0(Unknown Source)
at java.io.ObjectInputStream.readObject(Unknown Source)
at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:
90)
at
net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:
243)
at
org.apache.jsp.Admin.JasperReports_jsp._jspService(JasperReports_jsp.java:
58)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:
334)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:
314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:
178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:
107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
869)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:
664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:
527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:
80)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
*********************
this is my jasper report
<?xml version="1.0" encoding="UTF-8"?>
<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="monthly_custreport" language="groovy" pageWidth="800"
pageHeight="842" columnWidth="760" leftMargin="20" rightMargin="20"
topMargin="20" bottomMargin="20">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="26"/>
<style name="table" isDefault="false">
<box>
<pen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table_TH" isDefault="false" mode="Opaque"
backcolor="#8FAFCC">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_CH" isDefault="false" mode="Opaque"
backcolor="#CFDBE6">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_TD" isDefault="false" mode="Opaque"
backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<subDataset name="Table Dataset 1"/>
<queryString>
<![CDATA[SELECT
adid,
name,
add1,
mobilno,
email,
enrldate
FROM
`memberdetail` memberdetail
WHERE
enrldate >= 2010-5-1
and enrldate <= 2010-5-24
GROUP BY
adid
ORDER BY
1 ASC]]>
</queryString>
<field name="adid" class="java.lang.Integer"/>
<field name="name" class="java.lang.String"/>
<field name="add1" class="java.lang.String"/>
<field name="mobilno" class="java.lang.String"/>
<field name="email" class="java.lang.String"/>
<field name="enrldate" class="java.sql.Date"/>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="79" splitType="Stretch">
<staticText>
<reportElement x="187" y="26" width="180"
height="26"/>
<textElement>
<font fontName="Times New Roman"
size="14" isBold="true"
isUnderline="false"/>
</textElement>
<text><![CDATA[ Monthly Customer
Report]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="90" splitType="Stretch">
<textField pattern="EEEEE dd MMMMM yyyy">
<reportElement x="453" y="69" width="100"
height="20"/>
<textElement/>
<textFieldExpression
class="java.util.Date"><![CDATA[new
java.util.Date()]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="10" width="446"
height="20"/>
<textElement>
<font fontName="Times New Roman"
size="14" isBold="true"
isUnderline="true" isStrikeThrough="false"/>
</textElement>
<text><![CDATA[Nunber of Customer Joined
Between:-]]></text>
</staticText>
<staticText>
<reportElement x="0" y="49" width="228"
height="20"/>
<textElement>
<font fontName="Times New Roman"
size="14" isBold="true"/>
</textElement>
<text><![CDATA[Total Number of Customer
Joined:-]]></text>
</staticText>
</band>
</pageHeader>
<columnHeader>
<band height="79" splitType="Stretch">
<staticText>
<reportElement x="4" y="16" width="78"
height="20"/>
<textElement>
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Customer Id]]></text>
</staticText>
<staticText>
<reportElement x="109" y="16" width="133"
height="20"/>
<textElement>
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Customer Name]]></text>
</staticText>
<staticText>
<reportElement x="270" y="16" width="138"
height="20"/>
<textElement>
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Address]]></text>
</staticText>
<staticText>
<reportElement x="424" y="16" width="67"
height="20"/>
<textElement>
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Mobile No.]]></text>
</staticText>
<staticText>
<reportElement x="506" y="16" width="104"
height="20"/>
<textElement>
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Email]]></text>
</staticText>
<staticText>
<reportElement x="638" y="16" width="104"
height="20"/>
<textElement>
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Enroll Date]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="125" splitType="Stretch">
<textField>
<reportElement x="4" y="27" width="78"
height="20"/>
<textElement/>
<textFieldExpression class="java.lang.String"><!
[CDATA[$F{adid}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="109" y="27" width="133"
height="20"/>
<textElement/>
<textFieldExpression class="java.lang.String"><!
[CDATA[$F{name}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="270" y="27" width="138"
height="20"/>
<textElement/>
<textFieldExpression class="java.lang.String"><!
[CDATA[$F{add1}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="424" y="27" width="67"
height="20"/>
<textElement/>
<textFieldExpression class="java.lang.String"><!
[CDATA[$F{mobilno}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="506" y="27" width="104"
height="20"/>
<textElement/>
<textFieldExpression class="java.lang.String"><!
[CDATA[$F{email}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="638" y="27" width="100"
height="20"/>
<textElement/>
<textFieldExpression class="java.lang.String"><!
[CDATA[$F{enrldate}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="45" splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="54" splitType="Stretch">
<textField>
<reportElement x="466" y="27" width="80"
height="20"/>
<textElement textAlignment="Right"/>
<textFieldExpression
class="java.lang.String"><![CDATA["Page "+
$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
</textField>
<textField evaluationTime="Report">
<reportElement x="424" y="27" width="40"
height="20"/>
<textElement/>
<textFieldExpression
class="java.lang.String"><![CDATA[" " +
$V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
</band>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>
can any one tell me why it giving this exception and target it is
showing
--
You received this message because you are subscribed to the Google
Groups "Java EE (J2EE) Programming with Passion!" group.
To post to this group, send email to
java-ee-j2ee-programming-with-passion@googlegroups.com
To unsubscribe from this group, send email to
java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en
