Plugins (1059)

Training and Consulting (44)

EPIC Poll

What is your favourite developer portal?

[ Results | Polls ]

Votes: 541
Comments: 0

Log in to check your private messages Log in to check your private messages
Go to Administration Panel Go to Administration Panel
Error when filling a report that contains subreport
Eclipse Plugin Central Forum Index » Editor » JasperAssistant
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
MmarcoM
Post subject: Error when filling a report that contains subreport  PostPosted: Mar 11, 2005 - 06:52 AM



Joined: Mar 08, 2005
Posts: 12
hi all,
i have a report that contains a subreport.
I am passing the compiled subreport as Parameter to my main report, but when i fill hte mainReport i have following exception:

2005-03-11 11:24:39,172 ERROR (ReportGenerator.java:124): JRException while filling report: null
com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed
at com.ibm.db2.jcc.c.cc.bk(cc.java:3020)
at com.ibm.db2.jcc.c.cc.c(cc.java:254)
at com.ibm.db2.jcc.c.cc.next(cc.java:241)
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java:2408)
at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:121)
at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:867)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:164)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:684)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:120)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:291)
at com.waersystems.reports.util.ReportGenerator.generateReport(ReportGenerator.java:113)
at com.waersystems.reports.servlet.ReportServlet.doPost(ReportServlet.java:103)
at com.waersystems.reports.servlet.ReportServlet.doGet(ReportServlet.java:73)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:555)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:443)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)

NESTED BY :
net.sf.jasperreports.engine.JRException: Unable to get next record.
at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:125)
at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:867)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:164)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:684)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:120)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:291)
at com.waersystems.reports.util.ReportGenerator.generateReport(ReportGenerator.java:113)
at com.waersystems.reports.servlet.ReportServlet.doPost(ReportServlet.java:103)
at com.waersystems.reports.servlet.ReportServlet.doGet(ReportServlet.java:73)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:555)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:443)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)
Caused by: com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed
at com.ibm.db2.jcc.c.cc.bk(cc.java:3020)
at com.ibm.db2.jcc.c.cc.c(cc.java:254)
at com.ibm.db2.jcc.c.cc.next(cc.java:241)
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java:2408)
at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:121)
... 30 more
2005-03-11 11:24:39,188 INFO (ReportServlet.java:111): Error in generating a report..
com.waersystems.reports.util.ReportException: error_ngen error.general.export label_ngen null param_ngen null
at com.waersystems.reports.util.ReportGenerator.generateReport(ReportGenerator.java:124)
at com.waersystems.reports.servlet.ReportServlet.doPost(ReportServlet.java:103)
at com.waersystems.reports.servlet.ReportServlet.doGet(ReportServlet.java:73)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:555)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:443)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)
Caused by: net.sf.jasperreports.engine.JRException: Unable to get next record.
at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:125)
at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:867)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:164)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:684)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:120)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:291)
at com.waersystems.reports.util.ReportGenerator.generateReport(ReportGenerator.java:113)
... 23 more
Caused by: com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed
at com.ibm.db2.jcc.c.cc.bk(cc.java:3020)
at com.ibm.db2.jcc.c.cc.c(cc.java:254)
at com.ibm.db2.jcc.c.cc.next(cc.java:241)
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java:2408)
at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:121)
... 30 more


can anyone explain me what is the error?

In my code i am compiling first aliasReport, and then set it as parameter
for the mainReport.
then the mainReport get compiled.. and filled. and at the moment of filling it, i got the exception.
Anyone can help?
thanx and regards
marco


here is my two reports, shortagesReport.jrxml (main) and the aliasReport.jrxml (subreport),


-------------------------------\
shortagesReport.jrxml
---------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created using JasperAssistant (http://www.jasperassistant.com) -->
<!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport name="ShortagesReport" pageWidth="1100" pageHeight="670" orientation="Landscape" columnWidth="400" leftMargin="20" rightMargin="20" topMargin="0" bottomMargin="0">
<property name="com.jasperassistant.designer.DataSource" value="db2"/>
<import value="com.waersystems.reports.util.*"/>
<parameter name="DEMAND_TYPE" class="java.lang.Short">
<defaultValueExpression><![CDATA[new Short("0")]]></defaultValueExpression>
</parameter>
<parameter name="container" class="java.lang.String">
<defaultValueExpression><![CDATA["%"]]></defaultValueExpression>
</parameter>
<parameter name="owner" class="java.lang.String">
<defaultValueExpression><![CDATA["%"]]></defaultValueExpression>
</parameter>
<parameter name="aliasSubreport" class="net.sf.jasperreports.engine.JasperReport">
</parameter>
<queryString><![CDATA[select line.productRef, line.batchRef, line.outstandingquantity, line.uomref, line.duedate, header.destinationRef, line.warehouseref, line.ownerref from demandline line, demandheader header where line.productref like '%' and line.warehouseref like $P{container} and line.ownerref like $P{owner} and line.demandref = header.demandref and header.demandtype >=$P{DEMAND_TYPE} ORDER BY DUEDATE ASC]]></queryString>
<field name="PRODUCTREF" class="java.lang.String">
</field>
<field name="BATCHREF" class="java.lang.String">
</field>
<field name="OUTSTANDINGQUANTITY" class="java.math.BigDecimal">
</field>
<field name="UOMREF" class="java.lang.String">
</field>
<field name="DUEDATE" class="java.util.Date">
</field>
<field name="DESTINATIONREF" class="java.lang.String">
</field>
<field name="WAREHOUSEREF" class="java.lang.String">
</field>
<field name="OWNERREF" class="java.lang.String">
</field>
<variable name="Variable_2" class="java.lang.Integer" calculation="Count">
<variableExpression><![CDATA[$V{REPORT_COUNT}]]></variableExpression>
</variable>
<title>
<band>
<elementGroup>
</elementGroup>
</band>
</title>
<pageHeader>
<band height="64">
<staticText>
<reportElement positionType="Float" x="0" y="2" width="262" height="28" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="22" isBold="false" isItalic="false"/>
</textElement>
<text><![CDATA[Shortages Report]]></text>
</staticText>
<staticText>
<reportElement positionType="Float" x="541" y="35" width="126" height="20" forecolor="#2658a7"/>
<textElement verticalAlignment="Bottom">
<font fontName="Verdana" size="14" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[Project Code]]></text>
</staticText>
<staticText>
<reportElement positionType="Float" x="134" y="38" width="71" height="19" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="14" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[Alias]]></text>
</staticText>
<textField>
<reportElement x="816" y="1" width="63" height="15" isPrintWhenDetailOverflows="true" forecolor="#2658a7"/>
<textElement textAlignment="Right">
<font fontName="Verdana"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Page " + String.valueOf($V{PAGE_NUMBER}) + " of "]]></textFieldExpression>
</textField>
<textField evaluationTime="Report">
<reportElement x="885" y="1" width="29" height="15" isPrintWhenDetailOverflows="true" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[" " + String.valueOf($V{PAGE_NUMBER})]]></textFieldExpression>
</textField>
<staticText>
<reportElement positionType="Float" x="4" y="38" width="16" height="19" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="12" isBold="true"/>
</textElement>
<text><![CDATA[#]]></text>
</staticText>
<staticText>
<reportElement positionType="Float" x="668" y="29" width="76" height="27" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="10" isBold="false" isItalic="true"/>
</textElement>
<text><![CDATA[Warehouse /
Container]]></text>
</staticText>
<staticText>
<reportElement positionType="Float" x="223" y="36" width="126" height="19" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="14" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[Quantity Short]]></text>
</staticText>
<staticText>
<reportElement positionType="Float" x="361" y="36" width="71" height="19" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="14" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[UOM]]></text>
</staticText>
<staticText>
<reportElement positionType="Float" x="435" y="35" width="103" height="19" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="14" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[Date Short]]></text>
</staticText>
<staticText>
<reportElement positionType="Float" x="760" y="34" width="103" height="19" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="14" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[Owner]]></text>
</staticText>
<staticText>
<reportElement positionType="Float" x="40" y="37" width="82" height="19" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="14" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[Part Ref]]></text>
</staticText>
</band>
</pageHeader>
<columnHeader>
<band height="4">
<line>
<reportElement positionType="Float" x="0" y="2" width="901" height="1" forecolor="#2658a7"/>
<graphicElement pen="Thin"/>
</line>
</band>
</columnHeader>
<detail>
<band height="38">
<textField>
<reportElement positionType="Float" x="363" y="1" width="70" height="20" isPrintWhenDetailOverflows="true" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{UOMREF}]]></textFieldExpression>
</textField>
<textField>
<reportElement positionType="Float" x="0" y="0" width="29" height="23" isPrintWhenDetailOverflows="true" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="12"/>
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$V{Variable_2}]]></textFieldExpression>
</textField>
<textField>
<reportElement positionType="Float" x="241" y="-1" width="108" height="22" isPrintWhenDetailOverflows="true" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="12"/>
</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{OUTSTANDINGQUANTITY}]]></textFieldExpression>
</textField>
<textField>
<reportElement positionType="Float" x="439" y="0" width="89" height="20" isPrintWhenDetailOverflows="true" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="12"/>
</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[$F{DUEDATE}]]></textFieldExpression>
</textField>
<textField>
<reportElement positionType="Float" x="542" y="0" width="89" height="20" isPrintWhenDetailOverflows="true" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{DESTINATIONREF}]]></textFieldExpression>
</textField>
<textField>
<reportElement positionType="Float" x="670" y="0" width="89" height="20" isPrintWhenDetailOverflows="true" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{DESTINATIONREF}]]></textFieldExpression>
</textField>
<textField>
<reportElement positionType="Float" x="763" y="0" width="89" height="20" isPrintWhenDetailOverflows="true" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{OWNERREF}]]></textFieldExpression>
</textField>
<subreport isUsingCache="false">
<reportElement positionType="Float" x="133" y="-1" width="105" height="22"/>
<subreportParameter name="productref">
<subreportParameterExpression><![CDATA[$F{PRODUCTREF}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression class="net.sf.jasperreports.engine.JasperReport"><![CDATA[$P{aliasSubreport}]]></subreportExpression>
</subreport>
<textField>
<reportElement positionType="Float" isPrintRepeatedValues="false" x="34" y="2" width="95" height="22" isPrintWhenDetailOverflows="true" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{PRODUCTREF}]]></textFieldExpression>
</textField>
</band>
</detail>
<pageFooter>
<band height="22">
<line>
<reportElement positionType="Float" x="2" y="0" width="897" height="1" forecolor="#2658a7"/>
<graphicElement pen="None"/>
</line>
</band>
</pageFooter>
</jasperReport>

---------------------------
aliasReport.xml
--------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created using JasperAssistant (http://www.jasperassistant.com) -->
<!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport name="AliasReport" pageWidth="595" pageHeight="842" columnWidth="575" leftMargin="0" rightMargin="20" topMargin="0" bottomMargin="0">
<parameter name="productref" class="java.lang.String">
<defaultValueExpression><![CDATA["%"]]></defaultValueExpression>
</parameter>
<queryString><![CDATA[select aliasref from productcontactalias where productref=$P{productref} and primaryrefind=1]]></queryString>
<field name="aliasref" class="java.lang.String">
</field>
<detail>
<band height="26">
<textField>
<reportElement positionType="Float" x="1" y="0" width="123" height="20" forecolor="#2658a7"/>
<textElement>
<font fontName="Verdana" size="9"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{aliasref}]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>
 
 View user's profile Send private message  
Reply with quote Back to top
jasperassistant
Post subject:   PostPosted: Mar 14, 2005 - 02:35 AM



Joined: Feb 12, 2004
Posts: 519
Hi,

It looks like a JDBC driver bug or limitation. Try searching db2 forums for the error below:

Quote:
Caused by: com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed
at com.ibm.db2.jcc.c.cc.bk(cc.java:3020)
at com.ibm.db2.jcc.c.cc.c(cc.java:254)
at com.ibm.db2.jcc.c.cc.next(cc.java:241)
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java:2408)


It could be that the driver does not allow two result sets to be opened on the same JDBC connection. In this case you will have to open a second connection in your code and pass it to the subreport through a parameter of master report.

I hope this helps,

Peter Severin
- JasperAssistant Team

_________________
JasperAssistant Report Designer for JasperReports
http://www.JasperAssistant.com
 
 View user's profile Send private message Send e-mail Visit poster's website  
Reply with quote Back to top
nicholas.chk
Post subject: Solution available?  PostPosted: Feb 22, 2007 - 04:26 AM



Joined: Feb 22, 2007
Posts: 2
I am currently facing the same problem. There does not seem to be any solution posted or any closure to this issue. Is there a solution to this already? Please reply ASAP.
 
 View user's profile Send private message  
Reply with quote Back to top
sassy_java
Post subject: RE: Solution available?  PostPosted: Jan 08, 2008 - 03:22 AM



Joined: Jan 08, 2008
Posts: 4
i had used master report wherein there is several subreport inside

subreport uses Report connection wherein the query is defined
as a connection to my master report i also put a query on it like "select 1 from dual"
and it works fine on my report

hope it helps.
 
 View user's profile Send private message  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT - 6 Hours
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
 Eclipse Plugin Central Forum Index » Editor »  JasperAssistant
Powered by PNphpBB2 © 2003-2004 The PNphpBB Group
Credits