kishore_tech31

HI ALL, I have to display images from my blob column for that 1st-----i drag the image icon to the detail bar 2nd----image expression column name --$F{BLOB_CONTENT} 3rd-----expression class java.io.inputstream when i click preview it displays the following error, Please guide to solve this issue thanks in advance Error filling print... Error evaluating expression : Source text : $F{BLOB_CONTENT} net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $F{BLOB_CONTENT} at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:193) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:570) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:538) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:868) at net.sf.jasperreports.engine.fill.JRFillElement.evaluatePrintWhenExpression(JRFillElement.java:683) at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:880) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:256) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:482) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1868) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:726) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:252) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:110) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:921) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:824) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:59) 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:856) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object 'oracle.sql.BLOB@1653c0c' with class 'oracle.sql.BLOB' to class 'oracle.sql.BLOB' at org.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.castToType(DefaultTypeTransformation.java:340) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.castToType(ScriptBytecodeAdapter.java:632) at Drawing32Report32_1394283663673_499515.evaluate(calculator_Drawing32Report32_1394283663673_499515:227) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:182) ... 19 more Print not filled. Try to use an EmptyDataSource... Regards, kishore

Hi , I have to upload image to a blob column and the same thing has to be download from the column eg: upload -- need to upload the image by using items,that image have to be upload(insert) in to the blob column ,after the file has been uploaded need to download the image in PDF by using the download link empid | empname | age | sex | fileid | file_name | mime_type | blob_content 1 Jasper 23 M 123 XX.jpeg image/jpeg download file Thanks in advance Help me out Regards, Kishore