How add background image from Oracle database?

[Eyesmagicx]

Hi. 

I have TIBCO Jaspersoft® Studio 6.8.0 and Oracle's JDBC driver version 7 to connect to Oracle database XE. 

I have a table that has a BLOB column in which an image is stored. The image is a PNG but I can convert it to other image formats if needed.

Here is the query that retrieves the image...

select rosheta_img from rosheta_design;

The query retrieves one row. 

I need to set the retrieved image as a background for my report. I need it to cover all the page(including margins).

What is the best way to do that?

P.S I do not mind updating JasperSoft Studio or OJDBC or else if that could ease the task. 

Thanks a lot.

[Scott Andersen]

Check out this question/answer: https://community.jaspersoft.com/questions/1139756/print-image-blob-database-field

[Tom C]

Refer to:

 

https://community.jaspersoft.com/wiki/sample-report-display-image-stored-jasperreports-server-repository

[Eyesmagicx]

Change the expression of the image field of the dataset to inputStream. Then create an image element then set it's expression to that field.