[I have to display image from blobcolumn]

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

[Is it possible to add image in to Blob column]

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