Hi,
I am trying to generate image from postgresql bytea type field,
When i preview the report , then i getting error like below,
Error filling print... Error evaluating expression :
Source text : $F{binary}
net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :
Source text : $F{binary}
at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:195)
at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:589)
at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:557)
at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:929)
at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillImage.java:1023)
at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:1004)
at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:258)
at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:499)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:439)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:403)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:264)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:946)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)
at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:878)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
Caused by: java.lang.ClassCastException: [B cannot be cast to java.io.InputStream
at Test_1464690468421_172331.evaluate(Test_1464690468421_172331:163)
at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:182)
... 19 more
Print not filled. Try to use an EmptyDataSource...
Please help me how can i rectify this issue.
5 Answers:
Dear Sathees.k,
Please look at https://serhatcelik.wordpress.com/2015/07/15/how-to-show-blob-image-in-i...
I hope it helps you and please let me know if it works.
Good luck.
Check the following thread. It seems to be the same problem you're having and have a resolution too.
http://community.jaspersoft.com/questions/537110/postgresql-bytea-image-...
Dear Sathees.k,
Please look at https://serhatcelik.wordpress.com/2015/07/15/how-to-show-blob-image-in-i...
I hope it helps you and please let me know if it works.
Good luck.
Thank you for reply.
How can i add blob filed in my postgresql,can you please share me sample.
This is my Postgresql:
select im.binarydata
from nv_projectoverview po
inner join ad_image im on(im.ad_image_id = po.project_header_id