Convert image to BLOB

[pha...@payon.com.kh]

Hi,

Can we insert image to Oracle BLOB column?

Thanks!

[Catalin Roman]

Yes, we can.

[Phannin Yeat]

Thanks for your answer!!

 

JsonArray can't add BLOB value. Could you help me?

try {
        File file = new File("00002192.jpg");

        FileInputStream input = new FileInputStream(file);
        byte[] bytes = new byte[(int) file.length()];
        input.read(bytes);

        Blob blob = new SerialBlob(bytes);
         JsonArray params = new JsonArray();

         params.add("0").add("").add(blob.getBinaryStream());

} catch (Exception e) {
        e.printStackTrace();
}

Error Message

--
You received this message because you are subscribed to the Google Groups "vert.x" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vertx+un...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/vertx/4347370f-b4e2-48e0-9a94-1255276fbe3cn%40googlegroups.com.

[Catalin Roman]

OK, your question is not related to vertx, but here is an answer.

About inserting an "image" into an Oracle BLOB column... this is possible, because BLOB is the perfect data type to store binary data such as images.

Regarding the JSON part... JSON is a text standard, and you can't really use it to store binary data. However, you can do that if you encode the binary data to some text format such as BASE64.

There are several ways to do that.  For instance Java 8 has its own encoder eg:

String encodedInput = Base64.getEncoder().encodeToString(originalInput.getBytes());

-Catalin

To view this discussion on the web, visit https://groups.google.com/d/msgid/vertx/CACsDUmUS-9ABeneb%2BMQeWA4yYXWKjRVbDU2EG1OgnurJ3jNWAw%40mail.gmail.com.

[Phannin Yeat]

Thank you so much.

I found how to insert images in a binary stream. 

We can use java.sql.Connnection by the above code.

Connection jdbcConn = sqlConnection.unwrap();
Blob blob = jdbcConn.createBlob();
blob.setBinaryStream(1).write(bytes);
JsonArray params = new JsonArray().add(blob);

connection.queryWithParams("INSERT INTO XXX (b) VALUES (?)", params, handler);

To view this discussion on the web, visit https://groups.google.com/d/msgid/vertx/CALOz%2BjCf0mKJtdx3AnA1VGhfXOUfTOv7jL0Du2eKm2m4vt0bQA%40mail.gmail.com.