retrieve image from database blob data type

Asked Nov 23 '17 at 03:06

Active Apr 05 '18 at 06:34

Viewed 237 times

Good day sir, I'm having trouble in deploying image from database with a blob datatype. I tried path and it's working good. Now I want to try out Blob but I'm having trouble what code will I use. thanks in advance sir

database image value .

here's the code.

List<rec_item_med> recitemmed = new rec_item_med().findAll();

for (rec_item_med l : recitemmed){
    File file = new File("C:\\ecommerce\\first_ecom\\webcontent\\images\\items\\"+l.getString("No")+".png");
    FileOutputStream fileOutputStream = new FileOutputStream(file);
    byte[] bytes = l.getBytes("picture");
    InputStream inputStream = new ByteArrayInputStream(bytes);

    byte[] b = new byte[1024];
    while (inputStream.read(b) > 0) {
        fileOutputStream.write(b);
    }
}

edited Dec 11 '17 at 13:08

ipolevoy

5,432
2
31
46

asked Nov 23 '17 at 03:06

Kuya

Please include your code and exceptions if any – ipolevoy Nov 23 '17 at 04:49
So you want to retreive blob content from database...? – Hema Nov 23 '17 at 05:36
absolutely right – Kuya Nov 24 '17 at 06:51
@kuya, you are not providing any information that may help. I certainly used ActiveJDBC to store images and even PDFs before. – ipolevoy Nov 24 '17 at 18:11
@ipolevoy, My bad sorry for that. anyway I solved it already but is there any other way to store and retrieve image via active jdbc? here is what I did. (edited) – Kuya Dec 11 '17 at 09:16
I had to format your code to read it, and you were also missing a brace. I still do not understand if this is a problem or a question. – ipolevoy Dec 11 '17 at 13:09

retrieve image from database blob data type

0 Answers0