Get image from database into pdf file

Question

I am trying to create a pdf file from database and I am stuck at the image part, since Apache pdf box only accepts physical files and the images in my database are in blob format.

PDXObjectImage image = new PDJpeg(doc,rs.getBlob("image"));

Can anyone help me?

I would recommend storing the images on disk and instead store metadata about the images in the database (i.e. location/name etc) unless you really have to store them directly. See this thread, really puts light on the discussion stackoverflow.com/questions/3748/… — Tjernquist1
– Tjernquist1, Commented Dec 30, 2015 at 11:25

Benedikt Köppel · Accepted Answer · 2015-12-30 12:30:54Z

1

Convert your blob into an InputStream and pass this to PDJpeg:

Blob imageBlob = rs.getBlob("image");
try (InputStream imageInputStream = imageBlob.getBinaryStream()) {
    PDXObjectImage image = new PDJpeg(doc, imageInputStream);
}

edited Dec 30, 2015 at 12:30

answered Dec 30, 2015 at 11:24

Benedikt Köppel

5,1784 gold badges39 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rjdkolb Over a year ago

I am probably nit picking, but I would close that imageInputStream with a try with resources :)

Collectives™ on Stack Overflow

Get image from database into pdf file

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related