Add controler to simply use image in fields.binary

[kryskool]

Sinc V7 we have images of products, but we cannot directly use it in Jasper, because there was encode in base64 in the database,

Add new controler call url /jasper and display method to see the photo like we can do with a web browser

[BT-astauder]

Do you want to have the photo in a PDF? Then I have a solution for a configuration.

But I have never tried if it works also in a HTML report...

[kryskool]

Not yet, but when you add an image on iReport or Jasper Studio, just set on "Image expression" an address starts with http://...

On a test instance you can be like this one 'http://localhost:8069/jasper/display/product.product/image_small/15'

method: display
object: product.product
binary field: image_small
id of the product: 15

[BT-astauder]

After the properties (before the parameters) I added:
<import value="org.apache.commons.codec.binary.Base64"/>

Then define a image as follow (assuming that base64 encoded image is in 'signature'):
<image>
<reportElement x="254" y="13" width="301" height="101" uuid="29833ccf-c55d-4fa5-8502-bae6ea476344"/>
<imageExpression>
<![CDATA[new ByteArrayInputStream(new Base64().decodeBase64($F{signature}.getBytes("UTF-8")))]]>
</imageExpression>
</image>

[kryskool]

I have test this some month ago, but i always have an error, what can of type is $F{signature} ?

Thanks for the reply
Regards,

[BT-astauder]

It's a string:

<field name="signature" class="java.lang.String">
    <fieldDescription><![CDATA[signature]]></fieldDescription>
</field>

[kryskool]

Ok it's not a blob