rkm258

use below syntax 1. $P{parameter name} - This will be like ? in JDBC Prepared Stmt 2. $P!{parameter name} - This will just replace the text in the query, so u could use a part of sql query in it. 3. $X{IN/NOT IN, field, parameter name} See tutorials and docs in this community.

Even i get the same stackoverflow error, only on one of our prod server. There is a bug logged in the tracker for this. I suggest u to add ur info there. I found that for some reason when subreport doesn't fill in the remaining page and has to overflow, there is this error thrown, may be due to a deeply iterative logic. BUT it doesn't happen in one of our server, i have no reason for it. For now increasing your stack memory will be one option, but not a solution. I prefer using javaflow over thread, to avoid creating multiple threads. http://jasperforge.org/projects/jasperreports/tracker/view.php?id=4855

need more details, are the subreports accessible from the server. what is the subreport expression. more error comments and sample template will be helpful.

try using the the sql Blob's getBytes(long pos, int length) method to get the byte[]

You can use the hyperlinks functionality, where text fields, images and chart elements are the only ones supporting it. Specify the hyperlink of type 'External Reference' and provide the URL as hyperlinkReferenceExpression. I think PDF do support this as a link and open the page in a new window.

U can use a custom datasource and fill in the contents. Examples are in the dist. Post Edited by rmukkamalla at 07/29/2010 18:22

Hi, I had noticed that, whenever a subreport isn't able to fit in the same page of the main report, it does throw this exception. But sometimes i donot see this happening. I'am not exactly sure why, this happens. We are using two production servers, and this happens randomly on one of them. So I think my server resources are good, will investigate further. Thanks Ram

It is at http://sourceforge.net/tracker/?func=detail&aid=3025649&group_id=36382&atid=1121504

Use 'Print When Expression' property of the image element, of type java Boolean

Thank You, for reply. Added bug in sourceforge ID: 3025649. Hope this will be solved soon.

I notice these exception, only once in a while. The filling thread seems to be getting interrupted. Using JasperReports 3.7.2, running from Java Service Wrapper, called from Tomcat. Using JVM 1.6 Any suggestions to overcome this issue. [iNFO] 2010.07.02 11.46.57.738 | {com.dataart.spiral.middleware.MiddlewareImpl} LR: GetReportStatusLR UID:bba4a909-43da-4928-9876-4a76da16c701 [iNFO] 2010.07.02 11.46.57.864 | {com.dataart.spiral.services.handlers.report.GetReportStatusLRH} Request done: 126ms [iNFO] 2010.07.02 11.46.58.447 | {com.dataart.spiral.services.handlers.report.GenerateReportLRH} %% Exception in Report Execution:net.sf.jasperreports.engine.JRException: The report filling thread was interrupted. net.sf.jasperreports.engine.fill.JRFiller#fillReport[l: 62] net.sf.jasperreports.engine.JasperFillManager#fillReport[l: 417] com.dataart.spiral.services.handlers.report.GenerateReportLRH#handleRequest[l: 169] com.dataart.spiral.services.handlers.report.GenerateReportLRH#handleRequest[l: 42] com.dataart.spiral.services.lrc.HibernateLiteweightHandler#handleRequest[l: 43] com.dataart.spiral.middleware.MiddlewareImpl#processRequest[l: 274] sun.reflect.GeneratedMethodAccessor39#invoke[l: -1] sun.reflect.DelegatingMethodAccessorImpl#invoke[l: 25] java.lang.reflect.Method#invoke[l: 597] sun.rmi.server.UnicastServerRef#dispatch[l: 305] sun.rmi.transport.Transport$1#run[l: 159] java.security.AccessController#doPrivileged[l: -2] sun.rmi.transport.Transport#serviceCall[l: 155] sun.rmi.transport.tcp.TCPTransport#handleMessages[l: 535] sun.rmi.transport.tcp.TCPTransport$ConnectionHandler#run0[l: 790] sun.rmi.transport.tcp.TCPTransport$ConnectionHandler#run[l: 649] java.util.concurrent.ThreadPoolExecutor$Worker#runTask[l: 886] java.util.concurrent.ThreadPoolExecutor$Worker#run[l: 908] java.lang.Thread#run[l: 619] cause:net.sf.jasperreports.engine.fill.JRFillInterruptedException: null net.sf.jasperreports.engine.fill.JRFillBand#fill[l: 405] net.sf.jasperreports.engine.fill.JRFillBand#fill[l: 378] net.sf.jasperreports.engine.fill.JRVerticalFiller#fillBackground[l: 1802] net.sf.jasperreports.engine.fill.JRVerticalFiller#fillReportStart[l: 259] net.sf.jasperreports.engine.fill.JRVerticalFiller#fillReport[l: 127] net.sf.jasperreports.engine.fill.JRBaseFiller#fill[l: 938] net.sf.jasperreports.engine.fill.JRBaseFiller#fill[l: 841] net.sf.jasperreports.engine.fill.JRFiller#fillReport[l: 58] net.sf.jasperreports.engine.JasperFillManager#fillReport[l: 417] com.dataart.spiral.services.handlers.report.GenerateReportLRH#handleRequest[l: 169] com.dataart.spiral.services.handlers.report.GenerateReportLRH#handleRequest[l: 42] com.dataart.spiral.services.lrc.HibernateLiteweightHandler#handleRequest[l: 43] com.dataart.spiral.middleware.MiddlewareImpl#processRequest[l: 274] sun.reflect.GeneratedMethodAccessor39#invoke[l: -1] sun.reflect.DelegatingMethodAccessorImpl#invoke[l: 25] java.lang.reflect.Method#invoke[l: 597] sun.rmi.server.UnicastServerRef#dispatch[l: 305] sun.rmi.transport.Transport$1#run[l: 159] java.security.AccessController#doPrivileged[l: -2] sun.rmi.transport.Transport#serviceCall[l: 155] sun.rmi.transport.tcp.TCPTransport#handleMessages[l: 535] sun.rmi.transport.tcp.TCPTransport$ConnectionHandler#run0[l: 790] sun.rmi.transport.tcp.TCPTransport$ConnectionHandler#run[l: 649] java.util.concurrent.ThreadPoolExecutor$Worker#runTask[l: 886] java.util.concurrent.ThreadPoolExecutor$Worker#run[l: 908] java.lang.Thread#run[l: 619] [iNFO] 2010.07.02 11.46.58.447 | {com.dataart.spiral.services.handlers.report.GenerateReportLRH} Exception in Report to String:net.sf.jasperreports.engine.JRException: The report filling thread was interrupted. [iNFO] 2010.07.02 11.46.58.448 | {com.dataart.spiral.services.handlers.report.GenerateReportLRH} Request done: 1198ms [iNFO] 2010.07.02 11.46.58.450 | {com.dataart.spiral.middleware.MiddlewareImpl} LR: CUDReportStatusLR UID:null [iNFO] 2010.07.02 11.46.58.454 | {com.dataart.spiral.services.handlers.report.CUDReportStatusLRH} Transaction commit: 1+3ms Thanks Ram

I'am noticing this StackOverflow Error once in a while. Unable to know the real cause. It is getting hard to replicate as well. I'am using JasperReports Javaflow 3.7.2, in a Java Service Wrapper, called from Tomcat. Any help will be appreciated. Attached is the report template and its subreport. Also attached is a sample pdf report. Exception is thrown at : jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, session.connection()); // Hibernate Session is used. I'am using 3 subreports, where one of it has an expression of the form ($P{boolean_includePointsColumn}.booleanValue()?new File($P{path} + "TranscriptWithPicture_SubReport.jasper"):new File($P{path} + "TranscriptWithPicture_NoPoints_SubReport.jasper")) [iNFO] 2010.07.02 11.11.50.817 | {com.dataart.spiral.middleware.MiddlewareImpl} LR: GenerateReportLR UID:null [iNFO] 2010.07.02 11.11.51.053 | {com.dataart.spiral.services.handlers.report.GenerateReportLRH} Exception: net.sf.jasperreports.engine.JRRuntimeException: java.lang.StackOverflowError net.sf.jasperreports.engine.fill.JRFillSubreport#prepare[l: 710] net.sf.jasperreports.engine.fill.JRFillElementContainer#prepareElements[l: 329] net.sf.jasperreports.engine.fill.JRFillBand#fill[l: 419] net.sf.jasperreports.engine.fill.JRFillBand#fill[l: 378] net.sf.jasperreports.engine.fill.JRVerticalFiller#fillColumnBand[l: 2018] net.sf.jasperreports.engine.fill.JRVerticalFiller#fillDetail[l: 757] net.sf.jasperreports.engine.fill.JRVerticalFiller#fillReportStart[l: 269] net.sf.jasperreports.engine.fill.JRVerticalFiller#fillReport[l: 127] net.sf.jasperreports.engine.fill.JRBaseFiller#fill[l: 938] net.sf.jasperreports.engine.fill.JRBaseFiller#fill[l: 841] net.sf.jasperreports.engine.fill.JRFiller#fillReport[l: 58] net.sf.jasperreports.engine.JasperFillManager#fillReport[l: 417] com.dataart.spiral.services.handlers.report.GenerateReportLRH#handleRequest[l: 169] com.dataart.spiral.services.handlers.report.GenerateReportLRH#handleRequest[l: 42] com.dataart.spiral.services.lrc.HibernateLiteweightHandler#handleRequest[l: 43] com.dataart.spiral.middleware.MiddlewareImpl#processRequest[l: 274] sun.reflect.GeneratedMethodAccessor39#invoke[l: -1] sun.reflect.DelegatingMethodAccessorImpl#invoke[l: 25] java.lang.reflect.Method#invoke[l: 597] sun.rmi.server.UnicastServerRef#dispatch[l: 305] sun.rmi.transport.Transport$1#run[l: 159] java.security.AccessController#doPrivileged[l: -2] sun.rmi.transport.Transport#serviceCall[l: 155] sun.rmi.transport.tcp.TCPTransport#handleMessages[l: 535] sun.rmi.transport.tcp.TCPTransport$ConnectionHandler#run0[l: 790] sun.rmi.transport.tcp.TCPTransport$ConnectionHandler#run[l: 649] java.util.concurrent.ThreadPoolExecutor$Worker#runTask[l: 886] java.util.concurrent.ThreadPoolExecutor$Worker#run[l: 908] java.lang.Thread#run[l: 619] cause:java.lang.StackOverflowError: null java.util.HashMap$Entry#hashCode[l: 720] java.util.AbstractMap#hashCode[l: 461] java.util.HashMap$Entry#hashCode[l: 720] java.util.AbstractMap#hashCode[l: 461] java.util.HashMap$Entry#hashCode[l: 720] NOTE: THIS ABOVE HashMap LINE REPEATS AROUND SEVERAL HUNDREDS OF LINES

At the report level, set this attribute, whenNoDataType="NoDataSection" Include ur text fields and any others in the "No Data Section" band.

set "Stretch with Overflow" property to true. It will make the text field stretch vertically when the contents donot fit the element. Also make sure if there are any elements below this textfield, to make position type as 'float'. So that element below will move down relative to above elements.

jrxml is just an xml standard definition to represent a Reporting Template. U compile this template file using jaspereports API and fill it with data to generate a report.