Cannot Convert from SerialBlob to BLOB

Question

I am converting a document to byte array, After that, Converting that byte array to oracle BLOB object. But when I am converting I am getting error.

code -

ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
PdfWriter.getInstance(document, byteArrayOutputStream);
byte[] pdfBytes = byteArrayOutputStream.toByteArray();
BLOB blob = new javax.sql.rowset.serial.SerialBlob(pdfBytes);

Error -

 cannot convert from `SerialBlob` to BLOB

using JDBC or Hibernate – Ankur Singhal Feb 18 '15 at 06:49 — Ankur Singhal, Feb 18 '15 at 06:49
Can you please give an example? – ketan sharma Feb 18 '15 at 06:52 — ketan sharma, Feb 18 '15 at 06:52

score 1 · Accepted Answer · edited May 23 '17 at 12:25

You're mixing Oracle and Java 7 JDBC types here. BLOB is something which Oracle invented and which doesn't fit really well into the rest of the JDBC design which is one reason why you can't cast the two.

Either use java.sql.Blob or only use Oracle's types (i.e. replace SerialBlob with oracle.sql.BLOB plus the necessary streams).

Using Large Objects - Oracle JDBC Tutorial
Why I cannot cast oracle BLOB from native java Blob
Overcomplicated oracle jdbc BLOB handling

Cannot Convert from SerialBlob to BLOB

1 Answers1