How to view an image from blob column in Oracle with JasperReports?

by

Without seeing how you’re calling the blob to embed the image within your report code…

  1. Use blob.getBinaryStream().
  2. Convert the stream using javax.imageio.ImageIO.read( InputStream ).

For example:

javax.imageio.ImageIO.read( blob.getBinaryStream() )

This will return an instance of BufferedImage, which subclasses java.awt.Image, and should be a suitable object to embed in the report.

The blob variable shown in the example will have to use the appropriate variable from the report (that represents the data from the desired column).

See also:

More Related Contents:

  1. How to print several reports with barcode \ or several barcodes in one report
  2. having an exception when saving oracle type object in some entity
  3. Jasper Reports PDF doesn’t export cyrillic values
  4. Where’s my invalid character (ORA-00911)
  5. Using JasperReports with a relative path
  6. How to enable logging for SQL statements when using JDBC
  7. Change text field data color (Foreground color) based on condition in JasperReports
  8. Difference between Oracle jdbc driver classes?
  9. PLSQL JDBC: How to get last row ID?
  10. Cleanest way to build an SQL string in Java
  11. formatting a string to a currency format in jasper report
  12. How to show an image on jasper report?
  13. How to write / update Oracle blob in a reliable way?
  14. Setting Network Timeout for JDBC connection
  15. Unable to retrieve value from a JavaBean while generating reports using JasperReports API
  16. Call an Oracle function from Java
  17. My Jasper Template shows no text
  18. Cannot use a LIKE query in a JDBC PreparedStatement?
  19. How to collate multiple jrxml jasper reports into a one single pdf output file
  20. Can’t load jrxml located in jar file via JRXmlLoader: getting java.io.FileNotFoundException [duplicate]
  21. Hibernate Criteria for Dates
  22. JasperReport – wrap text to show long text in textfield
  23. JasperReports NoClassDefFoundError exception on net.sf.jasperreports.engine.util.JRStyledTextParser
  24. Hibernate native query – char(3) column
  25. Oracle JDBC : invalid username/password (ora-01017)
  26. How to fill report using JSON datasource without getting null values?
  27. PreparedStatement and setTimestamp in oracle jdbc
  28. Java: How to insert CLOB into oracle database
  29. How to add ojdbc7 to Java web app by Gradle?
  30. Passing the List of primitive type objects as datasource for subreport

Leave a Comment