linlinlin

I follow your step, first change datatype from blob to java.io.InputStream. now get another error: java.lang.OutOfMemoryError: Java heap space null looks like it will works . Thanks for help. All the best

Thanks for reply. I don't know when I change language from "java" to "groove" in report properties. Now I change back to "java". still has following error: I attach my screenshot. Compilation exceptions: com.jaspersoft.ireport.designer.compiler.ErrorsCollector@bbade4 net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Cannot cast from BLOB to InputStream value = (java.io.InputStream)(((oracle.sql.BLOB)field_PICTURE.getValue())); //$JR_EXPR_ID=9$ <----------------------------------------------------------------> 2. Cannot cast from BLOB to InputStream value = (java.io.InputStream)(((oracle.sql.BLOB)field_PICTURE.getOldValue())); //$JR_EXPR_ID=9$ <-------------------------------------------------------------------> 3. Cannot cast from BLOB to InputStream value = (java.io.InputStream)(((oracle.sql.BLOB)field_PICTURE.getValue())); //$JR_EXPR_ID=9$ <----------------------------------------------------------------> 3 errors at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:195) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:500) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Post Edited by linlinlin at 12/07/2010 21:24

hangman01, Thank you for your help. Now I can continue, but get follow error: Compilation running time: 996! Filling report... Locale: English (United States) Time zone: Default Error filling print... Error evaluating expression : Source text : $F{PICTURE} net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $F{PICTURE} at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:197) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:574) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:542) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:872) at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillImage.java:914) at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:895) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:260) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:486) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1427) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:729) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:256) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:114) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:911) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:814) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:421) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:251) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:864) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Caused by: org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object 'oracle.sql.BLOB@1e7ed58' 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 report12_1291742968897_49466.evaluate(calculator_report12_1291742968897_49466:289) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:186) ... 19 more Print not filled. Try to use an EmptyDataSource... Could you help me? Thanks a lot

Can anyone help please?

Thank you hangman01, You mean change datatype of the Blob field? It is blob type now, what datatype it should be? in my ireport,I can not choice the java.io.InputStream in expression class. THere is not that class. How can add it and I can choice it from ireport?

Can someone help me please, I am just using ireport. I need to get a Blob type column data from Oracle table. Why I can not find java.awt.Image class in expression class in ireport? there are some "java.lang.String","ava.lang.Boolean"....total 13. but no " java.awt.Image" Thanks a lot