Loading image from MSSQL from datatype image, not blob

[dario.griffo]

I'm trying to load an image from a MSSQL server but getting an error, the data type is image on an old sql server database, is not a blob

I tried setting the class to java.awt.Image, but it doesn't load

This is the exception I get

net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Unknown image source class [b

at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:466)

at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$18(ReportControler.java:441)

at com.jaspersoft.studio.editor.preview.view.control.ReportControler$4.run(ReportControler.java:333)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Caused by: net.sf.jasperreports.engine.JRException: Unknown image source class [b

at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillImage.java:562)

at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:472)

at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:259)

at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:456)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2067)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:788)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:298)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:152)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:963)

at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120)

at java.lang.Thread.run(Unknown Source)

 

Any ideas?

[hozawa]

How you looked at the following page?

http://stackoverflow.com/questions/15833031/jaspersoft-studio-report-how-to-insert-images-from-database

[dario.griffo]

Excellent! I didn't find the DataSet and Query Dialog, now I can load the image.

Thanks a lot!

[satheesh.k]

If i add in XML tab,showing blank page.Please help me